ActiveWindow.ScrollRow = 76 (Do I need this?)

[asmith5rgv]

Good Morning,
I have created macros in which I am getting good enough to edit and modify them using the VBA editor. Many times there is this code created by the macro:
ActiveWindow.ScrollRow = 76
ActiveWindow.ScrollRow = 54
ActiveWindow.ScrollRow = 44
ActiveWindow.ScrollRow = 33
ActiveWindow.ScrollRow = 12
ActiveWindow.ScrollRow = 1

sometimes it might go for a page or more incrementing the number. Can I take this out? It just makes for terrible reading!

Thanks,

Al

 

[Norie]

Al

Yes you can take it out.

When you record a macro everything you do, including scrolling, is recorded.

 

[erik.van.geit]

Hi,

YES! you can
these are only navigational commands
they do no operations at all

SELECT can be avoided to
all this slows down the process considerably

kind regards,
Erik

 

[asmith5rgv]

Thanks guys.