| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with dynamic ranges
Can anyone recommend a good book/site/resource for creating and
troubleshooting dynamic ranges & using OFFSET()? I need to get more general understanding of how they work with examples. Mine seem to expand the range but don't carry over the formatting. Thanks, -- JoAnn |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with dynamic ranges
Mine seem to expand the range but don't carry over the formatting.
Formulas* cannot carry over formats. They can only return values in the cells they are placed in. *any kind, inclusive OFFSET, dynamic ranges etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with dynamic ranges
Ok, thanks.
-- JoAnn "Max" wrote: Mine seem to expand the range but don't carry over the formatting. Formulas* cannot carry over formats. They can only return values in the cells they are placed in. *any kind, inclusive OFFSET, dynamic ranges etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Ranges | Excel Worksheet Functions | |||
| Dynamic ranges | Charts and Charting in Excel | |||
| Dynamic Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Linear Mode
