xlR1C1
 

Why doesn't this work?

a = activesheet.range("R1C1").value

xlR1C1
 

R stands for Rows, C stands for Colums, and you can only use R1C1 style in
the formulas.
In VBA, you can use Cells instead of R1C1 style like this.
Cells(Row index, Column Index)

So the code would be as follows.

a = ActiveSheet.Cells(1, 1).Value


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"AA" wrote in message
...
Why doesn't this work?

a = activesheet.range("R1C1").value