[Dima]

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

[Niek Otten]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[David Biddulph[_2_]]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[Bob I]

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

[Dima]

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

[Dima]

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

[Bob I]

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