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

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
>