SpecialCells(xlLastCell)
Not so easy
If you enter something in B21 and I3, the LastCell will be I21.
So I cannot check for LastCell = empty, and then delete the row
"José Ignacio Bella" escribió en el mensaje
...
sometimes it's so easy... i'll try it.
thx
"David" escribió en el mensaje
...
Hi Jose,
Using code to delete the row and then saving the file will change the
last
cell. Hope that helps.
"José Ignacio Bella" wrote:
Hello Group, I have a problem with a macro, and maybe you can help me
I use a sentence 'ActiveCell.SpecialCells(xlLastCell).Select' to go
to
the
last worksheet cell.
The problemis when this cell has been erased. Then it's not really the
last
cell, but Excel still points to this one.
Saving, closing and re-opening, then Excel points to the real last
cell.
Do you know how to refresh the xlLastCell without closing the book?
Thanks in advance.
|