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



Posted by Barrie Davidson on January 31, 2002 10:39 AM

Would this work for you?

Range("A2",Cells((conrows+1),(conrows+1))).Select

BarrieBarrie Davidson