referencing in the R[ ]C[ ] format
Posted by Henry Collet on January 31, 2002 10:31 AM
I want to select a square block of values and have a variable 'conrows' which defines trhe size of the square. The only way I can think of is to define use the range (top left cell, bottom right cell), with a R[ ] C[ ] to get to the bottom cell, as shown below. However it does not work. As not all cells are filled I cannot use a xlDown style reference. Any ideas?
Range("A2",r[(conrows+1)]c[(conrows+1)]).Select