Problems with re-setting the last active cell in an Excel workshee

R

Ryan

I am trying to re-set the last active cell on an Excel 2002 worksheet (in
this particular sheet it should be cell DA197). I have used both the methods
described in the Knowledge Base article (deleting rows and columns and
re-saving; and the Excess Format Cleaner add-in).

Deleting the rows and columns does not work; using the Excess Format Cleaner
does not work either and it then also hides the rows from 198 to 65536 - but
does not do the same for the columns.

I have checked that there is no protection on the worksheet.

Has anyone else come across this problem and if so can you please help?

Many thanks
 
N

Niek Otten

http://www.contextures.com/xlfaqApp.html#Unused

--
Kind regards,

Niek Otten

|I am trying to re-set the last active cell on an Excel 2002 worksheet (in
| this particular sheet it should be cell DA197). I have used both the methods
| described in the Knowledge Base article (deleting rows and columns and
| re-saving; and the Excess Format Cleaner add-in).
|
| Deleting the rows and columns does not work; using the Excess Format Cleaner
| does not work either and it then also hides the rows from 198 to 65536 - but
| does not do the same for the columns.
|
| I have checked that there is no protection on the worksheet.
|
| Has anyone else come across this problem and if so can you please help?
|
| Many thanks
 
R

Ryan

Thanks Niek, but I have already tried this and it hasn't worked. Any other
ideas?

Kind regards

Ryan
 
Top