ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Last cell (https://www.excelbanter.com/excel-discussion-misc-queries/18686-last-cell.html)

nc

Last cell
 
Hi

When I use the Edit GoTo Special "Last cell", a cell is
selected but the cell is blank. Why?

Thanks.

Bob Phillips

This usually means that the UsedRange has been altered, but Excel has not
refreshed itself.

See http://www.contextures.com/xlfaqApp.html#Unused for some solutions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in message
...
Hi

When I use the Edit GoTo Special "Last cell", a cell is
selected but the cell is blank. Why?

Thanks.





All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com