General Betting
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
sort by:
Show
per page
Replies: 2
|
By:
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 |
|
By:
Thank you, that looks like it will do the trick :)
|