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.

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.