using variables in visual basic range references
Posted by John on October 16, 2001 6:20 AM
I'm writing a macro in excel that I will be applying to several workbooks with varying numbers of rows. I would like to insert a variable (that describes the number of rows) into the range of cells that I select:
i.e., Range(RC:R@C).Select where @ is the number of rows that I want to select in each worksheet.
But so far, I've not been able to make this work.
One additional note to help keep this simple, the number of rows is listed in each workbook in the same cell (B1).
Thanks for your help.