| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 type refences in VBA for column identification
Range(Columns(1), Columns(3)).Select
John R. Reagan wrote: How can you use R1C1 type identification when refering to columns? I would like to replace the statement Columns("A:C").select with variables (say x and y) but cannot figure out the formating. The new statement would look something like Columns( x & ":" & y).select. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn off R1C1 reference type in Excel 2007? | Excel Worksheet Functions | |||
| Use dynamic column reference without R1C1 | Excel Worksheet Functions | |||
| Procedure to change Column heading from R1C1 to A1? | Excel Worksheet Functions | |||
| Cell Refences | Excel Worksheet Functions | |||
| Excel column identification | Setting up and Configuration of Excel | |||
Threaded Mode
