Wow can I switch to R1C1 mode?

Y

y

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.
 
S

Steve Garman

Sub test()
Dim sArea As Range
Set sArea = Application.InputBox(prompt:="Select range:", Type:=8)
MsgBox sArea.Address(ReferenceStyle:=xlR1C1)
End Sub
 
Top