Ok, then all is correct with the location Excel is identifying as Last
Cell. Perhaps there is something set in Print area that is doing this?

Dima wrote:

CTRL-G, Special, Last Cell takes me to the same cell BG473

"Bob I" wrote:


Where does CTRL-G, Special, Last Cell take you to now?

Dima wrote:


The prompt window to allow a macro does not appear when I open the other file
with the copy of the sheet.

"Bob I" wrote:



There is certainly more to this than meets the eye. Perhaps you want to
copy just that worksheet to a new workbook instead.

Dima wrote:


Thanks Bob for the suggestion!
I did not find a macro that accesses a cell on row 50147 and I deleted all
marcos in the Macro window. But I still get a a window asking if I want to
allow running of macros at the xls file opening.
Regards,
Dima
"Bob I" wrote:




Then perhaps you have a macro that accesses a cell on row 50147?

Dima wrote:



Thanks Bob for replying!
I did not delete contents. I deleted the rows with R-click menu Delete. (not
pressing Delete key)
Regards,
Dmitry

"Bob I" wrote:





Sounds like you deleted contents not the rows. Delete the rows with
R-click menu Delete.(not pressing Delete key)

Dima wrote:





Thanks Bob for replying!
I deleted all rows after 473. This does not resolve the problem in my file.
Regards,
Dmitry
"Bob I" wrote:






Select and delete all rows after 473.

Dima wrote:






Thanks Niek for replying!
I did what is written on http://www.contextures.com/xlfaqApp.html#unused
This does not change anything in my file.
My scrollbar goes to row 50147 -- my data ends in cell BG473.
Regards,
Dima

"Niek Otten" wrote:







Hi Dima,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dima" wrote in message
...






Hello!
A sheet scrolls to a data end with a vertical scroll bar in 1/50 of a
lenth
of a scroll bar area from the upper end.
How to make the sheet scroll to the data end with the scroll bar movement
to
the scroll bar area end?
Regards,
Dima