| 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 | |||
Hybrid Mode
