Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlR1C1
Why doesn't this work?
a = activesheet.range("R1C1").value |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|