Previous Topic Next Topic

Find last row of data in excel spreadsheet

Closed
jess - Sep 23, 2009 at 11:28 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2009 at 10:37 PM
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

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 23, 2009 at 10:37 PM
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.
2

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses