sometimes comfortable with the previous notation for region(eg.A1:B3)

  • Thread starter Thread starter kang
  • Start date Start date
K

kang

sometimes I'm comfortable with the previous notation for
region(eg.A1:B3) instead of [#this row],[column name].
how to change the way of notation?
thanks.
 
What is the question relating to Excel/VBA?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Office Button (top left)>Excel Options>Formulas, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| sometimes I'm comfortable with the previous notation for
| region(eg.A1:B3) instead of [#this row],[column name].
| how to change the way of notation?
| thanks.
 
Back
Top