Making last row of cell selection bold

[chadski778]

I have a rectangular block of cells selected and all cells in the selection contain data. How can I automatically select the final row and make it bold using VBA?

Thanks

 

[Jonmo1]

This will make the last row of the current selection bold.

Selection.Rows(Selection.Rows.Count).Font.Bold = True

 

[chadski778]

Thanks very much