Wow can I switch to R1C1 mode?

  • Thread starter Thread starter y
  • Start date Start date
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.
 
Sub test()
Dim sArea As Range
Set sArea = Application.InputBox(prompt:="Select range:", Type:=8)
MsgBox sArea.Address(ReferenceStyle:=xlR1C1)
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R1C1 notation in VBA code 7
setting more than one filter 1
R1C1 Formula 2
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 3
Pivot Table Macro with dynamic source data 1
input numbers for code 3
convert R1C1 (international) address to A1 0
help with dates in the past 5

Back
Top