| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wow can I switch to R1C1 mode?
This statement
Set sArea = Application.InputBox(prompt:="Select range:", Type:=8) returns an A1 reference to me. To set each seriesCollection.values of my chart I need an R1C1 reference. How could I accomplish this target? Thanks, Alex. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wow can I switch to R1C1 mode?
Sub test()
Dim sArea As Range Set sArea = Application.InputBox(prompt:="Select range:", Type:=8) MsgBox sArea.Address(ReferenceStyle:=xlR1C1) End Sub y wrote: This statement Set sArea = Application.InputBox(prompt:="Select range:", Type:=8) returns an A1 reference to me. To set each seriesCollection.values of my chart I need an R1C1 reference. How could I accomplish this target? Thanks, Alex. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why can't I switch to landscape mode? | Excel Discussion (Misc queries) | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Discussion (Misc queries) | |||
| help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 | Excel Worksheet Functions | |||
| I switched on the R1C1 reference style but I can't switch it off a | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Linear Mode
