Find last row of data in excel spreadsheet

Closed
jess - 23 Sep 2009 à 11:28
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Sep 2009 à 22:37
Hello,
I'm very new to VBA and macros. I have been tryong to find the last row of data in my excel spreadsheet and then make this bold in a macro so that i have the correct formatting month on month.

I have found some code that worked to give me the last row of data, buit i do not know how to then make this bold.

Please help!

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
23 Sep 2009 à 22:37
do you need a macro?
control+G and click" special"(left bottom) and click "last cell".
(in the middle of right hand column) . last cell is highlighted and that is the last row.