loop
"Wanna Learn" wrote:
Thanks Dave
I copied the macro, but it does not work . My last column that always has
data is Q. I am overlooking something , sorry I just don't get it. Please
clarify
"Dave Peterson" wrote:
Sometimes you don't need to loop.
If you can pick out a column that always has data when the row is used, you can
use that to find the last row.
Dim LastRow as long
With worksheets("Sheet1")
lastrow = .cells(.rows.count,"X").end(xlup).row
'then format .rows(lastrow)
end with
Wanna Learn wrote:
I created a macro and it works fine, however I want to add a loop. (Hope
that is the term) I want to be able to go to the last row in the worksheet
and highlight the row in grey and make the font bold .
--
Dave Peterson
|