Range formula is causing me error 1004.

[redsab]

Does any one know why I can't get this vba line to work correctly?

Please Login or Register  to view this content.

where R = 3.
I get the following error:

Run-time error '1004'
Method 'Range' of object '_Global' failed

What I'm shooting for is:

Please Login or Register  to view this content.

Thanks
redsab

[PCI]

See

Please Login or Register  to view this content.

[redsab]

That was my initial formula and it did not work. Thanks

[PCI]

What do you mean by " it did not work."
Do you have still the error message ?
See my test file attached

[protonLeah]

If R is already numeric,

Cells(R,"F").Activate

or
Range ("F" & R).Activate

[redsab]

Yes PCI,
Your line works 100%. Sorry, it was my error. Did you see I used .Active instead of .Activate. It's just those small little errors you just don't notice. Thanks PCI

[redsab]

Thanks protonLeah, I think I will use that formula instead, that makes it a little easier.
redsab