98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Formatting
Formatting
Resolved · Low Priority · Version 2003
Fri 7 May 2010, 15:55Delegate Fiona said...
Fiona has attended:
Excel VBA Intro Intermediate course
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?
Tue 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 = Truesets the last line font to bold
Hope this helps
Regards
Stephen
Mon 17 May 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |
