View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
y y is offline
external usenet poster
 
Posts: 60
Default 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.