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
