I know that saving the workbook will reset that immediately.
I could have sworn there was a command to do it, but my addled brain
can't seem to remember :(


On Jun 13, 4:24 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
Not reliably. Try this... put some data in some of the rows out toColumn5
on a sheet and then put something in J3. Go to the Immediate window and
enter this...

? ActiveCell.SpecialCells(xlLastCell).Column

It should print out 10. Now issue this command in the Immediate window

Range("J3").Delete

That will remove the entry from J3 that you just put in it. Look at the
worksheet... thelastusedcolumnis now 5. Go back and execute this line
again...

? ActiveCell.SpecialCells(xlLastCell).Column

It should still print out 10.

Rick

"Reitanos" wrote in message

...

Can't you just use
ActiveCell.SpecialCells(xlLastCell).Select

On Jun 13, 2:43 pm, guest wrote:
is there a way to findlastcolumnthat has data in a given worksheet??
without selecting the range of data.