| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.Select with variable cells ?
Hello,
I am having a devil of a time trying to find out how to use Range.Select (or something else) with rows and columns that vary. row1 = x1 row2 = x2 col1 = y1 col2 = y2 x1=1 x2=2 y1=1 y2=2 Range(R[x1]C[y1]:R[x2]C[y2]).Select or Range(R[x1]C[y1+1]:R[x1]C[y2+2]).Select is what I am trying to accomplish but I keep getting errors. How do I use the Range statement (or something else) in the above statements? Lance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a variable range | Excel Worksheet Functions | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Using a variable for range of cells | Excel Discussion (Misc queries) | |||
| Use a Variable to select a range | Excel Discussion (Misc queries) | |||
| Range("C9:V9").Select ==> changing the 9 to a variable | Excel Worksheet Functions | |||
Threaded Mode
