Colleen45
Active Member
- Joined
- Jul 22, 2007
- Messages
- 495
How would this VBA be tidied up?
ActiveWindow.ScrollRow = 960
ActiveWindow.ScrollRow = 957
ActiveWindow.ScrollRow = 955
ActiveWindow.ScrollRow = 950
ActiveWindow.ScrollRow = 946
ActiveWindow.ScrollRow = 942
ActiveWindow.ScrollRow = 939
ActiveWindow.ScrollRow = 933
ActiveWindow.ScrollRow = 928
ActiveWindow.ScrollRow = 921
ActiveWindow.ScrollRow = 915
ActiveWindow.ScrollRow = 909
ActiveWindow.ScrollRow = 904
ActiveWindow.ScrollRow = 897
ActiveWindow.ScrollRow = 891
ActiveWindow.ScrollRow = 884
ActiveWindow.ScrollRow = 877
ActiveWindow.ScrollRow = 871
ActiveWindow.ScrollRow = 863
ActiveWindow.ScrollRow = 858
ActiveWindow.ScrollRow = 854
ActiveWindow.ScrollRow = 846
ActiveWindow.ScrollRow = 841
ActiveWindow.ScrollRow = 834
ActiveWindow.ScrollRow = 829
ActiveWindow.ScrollRow = 821
ActiveWindow.ScrollRow = 809
ActiveWindow.ScrollRow = 793
ActiveWindow.ScrollRow = 786
ActiveWindow.ScrollRow = 777
ActiveWindow.ScrollRow = 768
ActiveWindow.ScrollRow = 758
ActiveWindow.ScrollRow = 960
ActiveWindow.ScrollRow = 957
ActiveWindow.ScrollRow = 955
ActiveWindow.ScrollRow = 950
ActiveWindow.ScrollRow = 946
ActiveWindow.ScrollRow = 942
ActiveWindow.ScrollRow = 939
ActiveWindow.ScrollRow = 933
ActiveWindow.ScrollRow = 928
ActiveWindow.ScrollRow = 921
ActiveWindow.ScrollRow = 915
ActiveWindow.ScrollRow = 909
ActiveWindow.ScrollRow = 904
ActiveWindow.ScrollRow = 897
ActiveWindow.ScrollRow = 891
ActiveWindow.ScrollRow = 884
ActiveWindow.ScrollRow = 877
ActiveWindow.ScrollRow = 871
ActiveWindow.ScrollRow = 863
ActiveWindow.ScrollRow = 858
ActiveWindow.ScrollRow = 854
ActiveWindow.ScrollRow = 846
ActiveWindow.ScrollRow = 841
ActiveWindow.ScrollRow = 834
ActiveWindow.ScrollRow = 829
ActiveWindow.ScrollRow = 821
ActiveWindow.ScrollRow = 809
ActiveWindow.ScrollRow = 793
ActiveWindow.ScrollRow = 786
ActiveWindow.ScrollRow = 777
ActiveWindow.ScrollRow = 768
ActiveWindow.ScrollRow = 758