Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

Are you sure that you remembered to save, close the file, and reopen?
--
David Biddulph

"Dima" wrote in message
...
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

Scroll bar moves too short
 

Thanks David for replying!
I'm sure that I saved, closed the file, and reopened.

"David Biddulph" wrote:

Are you sure that you remembered to save, close the file, and reopen?
--
David Biddulph

"Dima" wrote in message
...
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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

Thanks Bob for your suggestion!
The problem exists in the copy in another work book too.

"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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

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

Scroll bar moves too short
 

Thanks Bob for suggesting!
The print area ends in row 472.

"Bob I" wrote:

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

Scroll bar moves too short
 

I still have not resolved the problem.

"Bob I" wrote:

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

Scroll bar moves too short
 

We have exhausted the items that I know of, perhaps you may run Office
Diagnostics on the Office installation.

Dima wrote:

I still have not resolved the problem.

"Bob I" wrote:


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