One way:

Worksheets(X).Rows(W).Copy Destination:=Worksheets(Z).Rows(Y)




In article , glenn
wrote:



Hi all


How do i write "Get row W from worksheet X and copy row W to row Y
(inserting row W in the position where row Y is) on worksheet Z" in VBA?

WXYZ would be variables in my script.

Thanks!