First empty row after last used row
Cells(Rows.Count,"A").End(xlUp)..Offset(1,0).Selec t
but you probably don't need the select, you can do most things without
selecting
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Juan" wrote in message
...
Hello,
I want to format the first empty row after the last used
row. IF I use
Range("A65536").End(xlUp).EntireRow.Select
But this won't work. Been locking for similar post but the
ones I tried i can't seem to get it to work.
Can anyone give some info?
I want to put totals on this row.
Thanks,
juan
|