Find the last row and column of the dirty area
Sub ThisIsIt()
Dim rngCorner As Range
Set rngCorner = Cells.SpecialCells(xlCellTypeLastCell)
MsgBox rngCorner.Address
End Sub
--
Jim Cone
Portland, Oregon USA
"MarkS"
wrote in message
Hi,
My problem is that if you enter a value in a cell in say row 65,000 and then
delete it excel will still think the sheet goes to row 65,000. I need to know
what row and column Excel thinks the sheet goes to.
I've found lots of ways to get it to find the real answer but nothing on how
to find out what excel thinks it is.
Thanks MarkS
|