VBA error inserting copied data - why?

[KMack22]

I am trying to insert copied data from one wksht to another. I have written a macro and when I run it and I am getting error code 1004: cannot shift objects off sheet and don't know why.

Here is my code:

Range("A4").Select
Sheets("Data Entry").Range("A4:AG" & Sheets("Data Entry").Range("A4").End(xlDown).Row).Select
Selection.Copy
Sheets("Historical Data").Select
Rows("4:4").Select

(this line below is the one that stops and highlights the error):
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False

does anyone know why it is doing that?

 

[VoG]

This may help http://support.microsoft.com/kb/211769

 

[KMack22]

thanks Peter! I read what Microsoft had to say to fix. Ended up going another route though. I inserted the data rather than rows and it worked fine. not sure why, but happy it's fixed.

I hadn't thought to go to Microsoft and type in the exact error - I will do that next time. thanks!