The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Formatting

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Formatting

Resolved · Low Priority · Version 2003

ReplyFri 7 May 2010, 15:55Delegate Fiona said...

Formatting

How do you format only the last line of a list of data? For example, if the last line is the total, how do you make sure that only that line is bold if you don't know what line the end line is?

For upcoming training course dates see: Pricing & availability

ReplyTue 11 May 2010, 11:35Trainer Stephen said...

RE: Formatting

Hi Fiona

Thanks for your question

You can select the last line by counting the rows in the current region. So

Range(Cells(Range("A7").CurrentRegion.Rows.Count, 1), _

        Cells(Range("A7").CurrentRegion.Rows.Count, 5)).Font.Bold = True

sets the last line font to bold

Hope this helps

Regards

Stephen

Mon 17 May 2010: Automatically marked as resolved.

Excel articles

· Jazzing Up Excel With Graphics
· Backstage Management With Excel 2010
· How To Ensure You Always Make A Complete Data Recovery
· The Importance of Data Backups
· The Mysteries Of Excel Explained

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Can I get a discount on the advanced course?

» Forum post: Excel 2007

Keeping Your Access Database Updated

When it comes to changing data, deleting tables or adding lots of new information to your Access database, check out the features that let you complete all these tasks quickly and efficiently.

» Article: Access training london

Rate this page: