View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Last cell in worksheet

I believe the necessity for that action Ron, goes way back to XL97, or *PRE*
XL97!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ron de Bruin" wrote in message
...
When you save your workbook, the last cell is refreshed from row 126 to
row 66.


Not in every version, sometimes you must close/reopen the file

See also this page if you want to use code
http://www.rondebruin.nl/last.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gary Brown" wrote in message
...
When you save your workbook, the last cell is refreshed from row 126 to
row 66.
--
Hope this helps. If this post was helpfull, please remember to click on
the ''''YES'''' button at the bottom of the screen.
Thanks,
Gary Brown


"dp" wrote:

After I logged on here and posted, I returned to this file and now I get
the correct last cell. Did it just take 5 minutes or so for the changes
to register?

Still trying to catch on!
dp "dp" wrote:

I only wanted the first 66 rows of a file, so I highlighted and
deleted rows 67 - 126. If I use ctr-end (or go-to last cell) it takes
me to R126. How can i find out what is in that cell?
Excel 2003, Windows Prof 2000

thanks
dp