Help in paste to

[Annebee]

Any help would be appreciated.

from the Feb worksheet I am trying to
create a macro to
copy range A21 to X 27 from worksheet named "Info"
return to the Feb worksheet
paste the copied range to the next available cell
I have programed as below and it works, but will not paste in the next available cell in Feb.


Sheets("Info").Select
Range("A21:X27").Select
Selection.Copy
Selection.Copy Destination:=Sheets("feb").Range("A" & Rows.Count).End(xlUp).Offset(1)
Sheets("Feb").Select

 

[VoG]

try replacing that with

Sheets("Info").Range("A21:X27").Copy Destination:=Sheets("feb").Range("A" & Rows.Count).End(xlUp).Offset(1)

 

[Annebee]

Perfect!!

I guess I need to read a little bit further in my programing book, I am coming along little by little

Thank you for your help!!