How to reference variable worksheets and variable row

  • Thread starter Thread starter glenn
  • Start date Start date
G

glenn

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!
 
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 said:
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?
Click to expand...

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup and copy cells if match found 2
Range passed to a function - trying to just move through the range 4
Reference a workbook level named variable. 8
Unmerge cells and fill duplicate data 5
Assign Selection to a Variable 2
Simple Variable to someone 5
Copy rows to another sheet 6
Excel VBA help: Text file formatting 19

Back
Top