I found Tom Ogilvy's answer on "How to restrict scroll area in Excel
Programming" dated dated 3/23/05 just what I needed in my program.

However, I have a remaining issue. The scroll box on my Worksheet is very
tiny and when I move it at all it scrolls very rapidly to the bottom of the
scroll area.

Is the a way to control the increment rate down the Worksheet as the box is
moved with macro code?

Thanks for your help.

Jim

Maybe you can reset the used range.

Visit Debra Dalgleish's site for some techniques:
http://contextures.com/xlfaqApp.html#Unused

jswalsh33 wrote:

I found Tom Ogilvy's answer on "How to restrict scroll area in Excel
Programming" dated dated 3/23/05 just what I needed in my program.

However, I have a remaining issue. The scroll box on my Worksheet is very
tiny and when I move it at all it scrolls very rapidly to the bottom of the
scroll area.

Is the a way to control the increment rate down the Worksheet as the box is
moved with macro code?

Thanks for your help.

Jim

--

Dave Peterson

Thanks Dave, that solved the problem

Jim

"Dave Peterson" wrote:

Maybe you can reset the used range.

Visit Debra Dalgleish's site for some techniques:
http://contextures.com/xlfaqApp.html#Unused

jswalsh33 wrote:

I found Tom Ogilvy's answer on "How to restrict scroll area in Excel
Programming" dated dated 3/23/05 just what I needed in my program.

However, I have a remaining issue. The scroll box on my Worksheet is very
tiny and when I move it at all it scrolls very rapidly to the bottom of the
scroll area.

Is the a way to control the increment rate down the Worksheet as the box is
moved with macro code?

Thanks for your help.

Jim

--

Dave Peterson