MrExcel Publishing
Your One Stop for Excel Tips & Solutions

CSE array question


Posted by Carl B on March 08, 2001 12:51 AM

Is it possible to select an entire column for use with CSE's, I.E., $A:$A


Posted by Aladin Akyurek on March 08, 2001 1:44 AM

Hi Carl,

The answer is no. The reason, to my knowledge, is unknown.

But, you can do what you want to accomplish by using a named dynamic range, for example, by using the name of the range in the array formula.

Aladin

Posted by Carl B on March 08, 2001 8:36 PM

Thank you Aladin.
I was trying to use a CSE with an entire column and was getting either #Value or #Num error. I did change the named range to reflect a portion of the column and it worked like a charm.