Hi experts:

When I create a macro to copy and then paste a range consintis of 1000 lines
in the same sheet, I used scroll down, it works OK for one sheet.

Since I want to do it for doing the same type of job for the other 8 sheets
by combining the same VBA text, Coz I want just to have 1 button to do it,
but the message is " PROCEDURE IS TO BIG"

My question is, is there any VBA function, jsut to memtopm copy to range say
"A1... to X1000) than can replace the following lot lines:
Selection.Copy
Range("N12:N1004").Select
ActiveSheet.Paste
Range("N9:X1002").Select
ActiveWindow.SmallScroll Down:=-11
ActiveWindow.ScrollRow = 980
ActiveWindow.ScrollRow = 978... this will go al the way down to line
---1000
.........

Thanks for any idea.

Frank