| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 type refences in VBA for column identification
another road to Rome..
Activesheet.Columns(1).Resize(,3).Select keepITcool JWolf wrote: Range(Columns(1), Columns(3)).Select John R. Reagan wrote: would look something like Columns( x & ":" & y).select. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 type refences in VBA for column identification
Thanks!
|
| Reply |
| 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 | |||
Linear Mode
