Help with dynamic ranges

  • Thread starter Thread starter JoAnn
  • Start date Start date
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,
 
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

---
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill a dynamic range with a formula. 1
Conditional formatting on a dynamic range - workaround 1
Multiple Dynamic Named Ranges across Columns 3
Dynamic Range for multiple columns 7
Capturing dynamic ranges 10
Drop Down with dynamic named range offsheet source list 14
concatenate dynamic ranges 7
hLookup dynamic range 2

Back
Top