Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA determine computer region | Setting up and Configuration of Excel | |||
Region | Excel Discussion (Misc queries) | |||
need to zoom in a particular region of graph | Charts and Charting in Excel | |||
Is it possible to count if within a number region? | Excel Discussion (Misc queries) | |||
how to shrink a region (because of a maverick) | Charts and Charting in Excel |