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