Help with dynamic ranges

J

JoAnn

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,
 
M

Max

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
 
J

JoAnn

Ok, thanks.
--
JoAnn


Max said:
Formulas* cannot carry over formats.
They can only return values in the cells they are placed in.
*any kind, inclusive OFFSET, dynamic ranges etc
Click to expand...
 
Top