Complicated naming/group referencing question

A

Alex

I would like to know if it is possible to...

1. Define/Name a range based on format (color, font, etc.)

2. Reference a range based on format in another worksheet

3. Further define a range already based on format by
columns in another worksheet

Thanks in advance, any help would be much appreciated.
 
F

Frank Kabel

Hi Alex
could only be achieved with VBA. Maybe you could explain what your goal
is. There' may be easier solutions
 

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

Conditional formatting 2
How do I have a cell value define a dynamic named range? 15
List all tables, including document structure 0
How to get range names to Apply across multiple tabs 1
Formatted cell column in drop down list 1
using a defined Name in a function 2
Dynamic Named Ranges 3
VLOOKUP or SUMIF for Multiple Criteria 2

Top