What version of Excel are you using?

The cells that contain formula blanks, are they at one end of the range or
at random locations within the range?

--
Biff
Microsoft Excel MVP


"The Narcissist" wrote in message
...
Hi All,

I'm using some dynamic ranges on an excel file I'm working on. One range
has
a problem though. The column contains fomulas and the default result is a
blank. When I reference this range, it also takes in the blank values.
This
is impacting some other fomulas on the file. Is there a way I can modify
the
range to exclude blanks?

This is how the range is defined.

=Application!$L$2:INDEX(Application!$L:$L,COUNTA(A pplication!$L:$L))

Any help would be greatly appreciated.

Thanks,

Sam