Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula that sums/counts across worksheets with variable reference | Excel Discussion (Misc queries) | |||
reference other worksheets via variable names | Excel Worksheet Functions | |||
Using variable as row reference in VBA | Excel Programming | |||
Variable reference | Excel Programming | |||
Using a variable as a row reference? | Excel Programming |