Last cell in worksheet
 

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

Last cell in worksheet
 

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

Last cell in worksheet
 

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

Last cell in worksheet
 

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

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