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