| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
R1C1 Notation in VBA
Excel 2000
Is it possible to use R1C1 notation in VBA? I'm using it in cell formulae notation. Range("A1").Select of course works. However, Range("R1C1").Select bombs. Thanks, Fred Holmes |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 Notation in VBA
try
Cells(1, 1).select -- HTH... Jim Thomlinson "Fred Holmes" wrote: Excel 2000 Is it possible to use R1C1 notation in VBA? I'm using it in cell formulae notation. Range("A1").Select of course works. However, Range("R1C1").Select bombs. Thanks, Fred Holmes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| Range R1C1 notation & the problem with my Macro | Excel Programming | |||
| Using Range with R1C1 notation in a macro | Excel Programming | |||
| Absolute reference in R1C1 notation | Excel Programming | |||
| R1C1 Notation | Excel Programming | |||
Linear Mode
