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

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.

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

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)

"kang" wrote in message
...
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.

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

not vba.
just excel 2007.

Bob Phillips wrote:
What is the question relating to Excel/VBA?

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

Office Button (top left)Excel OptionsFormulas, uncheck R1C1 reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"kang" wrote in message ...
| 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.

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

it works. thanks.

Niek Otten wrote:
Office Button (top left)Excel OptionsFormulas, uncheck R1C1 reference style