General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I use for example
Range("D11:G209").copy
I want to replace the numbers above with variables depending on what my macro finds.
So the macro trawls down a list of data, stops at a row, and that row reference should replace the 209 above.
thanks
Range("D11:G209").copy
I want to replace the numbers above with variables depending on what my macro finds.
So the macro trawls down a list of data, stops at a row, and that row reference should replace the 209 above.
thanks
Show More
You could use the cells freference. Eg in your example it translates as
Range(Cells(11, 4), Cells(209,7)).Copy
use a variable in place of 209 to indicate the row:
Range(Cells(11, 4), Cells(this_row,7)).Copy
Range(Cells(11, 4), Cells(209,7)).Copy
use a variable in place of 209 to indicate the row:
Range(Cells(11, 4), Cells(this_row,7)).Copy
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539