Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Named Ranges shown (or not shown) as blue means what?
I am having trouble getting the following formula from cpearson's page to work:
IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)-COUNTBLANK(BlanksRange),"", INDIRECT(ADDRESS(SMALL((IF(BlanksRange<"",ROW(Bla nksRange),ROW()+ROWS(BlanksRange))), ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4))) It removes blank cells from a list and has worked for me before. This time I notice that when I type in a named range into the formula, it turns blue (I assume indicating that Excel recognizes it as a variable name). But, only one of the two named ranges turns blue, and I am getting a circular reference error. Insight into the blue color in relation to named ranges? Thanks in advance, Billy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |