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

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

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

--
Kind regards,

Niek Otten

"Ryan" <[email protected]> wrote in message news:[email protected]...
|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

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

Kind regards

Ryan

"Niek Otten" wrote:

> http://www.contextures.com/xlfaqApp.html#Unused
>
> --
> Kind regards,
>
> Niek Otten
>
> "Ryan" <[email protected]> wrote in message news:[email protected]...
> |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
>
>
>