New Posts For Thread: help with excel code pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23870518/help-with-excel-code-pleaseI use for exampleRange("D11:G209").copyI 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.thanksThank you, that looks like it will do the trick :)https://community.betfair.com/general_betting/go/thread/view/94082/23870518/help-with-excel-code-please?post_id=430346486#430346486Thank you, that looks like it will do the trick :)Sat, 01 May 2010 12:31:36 -0500You could use the cells freference. Eg in your example it translates as Range(Cells(11, 4), Cells(209,7)).Copyuse a variable in place of 209 to indicate the row:Range(Cells(11, 4), Cells(this_row,7)).Copyhttps://community.betfair.com/general_betting/go/thread/view/94082/23870518/help-with-excel-code-please?post_id=430346482#430346482You could use the cells freference. Eg in your example it translates as Range(Cells(11, 4), Cells(209,7)).Copyuse a variable in place of 209 to indicate the row:Range(Cells(11, 4), Cells(this_row,7)).CopySat, 01 May 2010 12:19:56 -0500I use for exampleRange("D11:G209").copyI 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.thankshttps://community.betfair.com/general_betting/go/thread/view/94082/23870518/help-with-excel-code-please?post_id=430346478#430346478I use for exampleRange("D11:G209").copyI 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.thanksSat, 01 May 2010 11:41:14 -0500