How to reference variable worksheets and variable row
 

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!

How to reference variable worksheets and variable row
 

Hi glenn:

After we get row W, should we just put the data into row Y, or insert a new
row above Y and put the data into the newly inserted row?
--
Gary''s Student - gsnu200747


"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!

How to reference variable worksheets and variable row
 

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!

How to reference variable worksheets and variable row
 

Gary''s Student wrote:
Hi glenn:

After we get row W, should we just put the data into row Y, or insert a new
row above Y and put the data into the newly inserted row?

Hi thanks to everybody for the answers.

Yes, insert a new row above Y an put the data from row W into the newly
inserted row! Like whe you want to copy columns headers rows to another
worksheet that contains data.

thanks!