Counting number of non-blank cells in column......but getting run time error in vba

Hi,

I have set up a range in vba as follows (see rngsourcedata):

Please Login or Register  to view this content.

The problem is that if status_col is "empty" then i get a run time error.

I thought if a range is empty that it would evaluate to "Nothing"......not cause a runtime error.......


any thoughts/ideas?

That particular function returns a valid reference or an error. It's the same as doing Goto > Special > Constants. That would return a dialog reporting no cells found.

So you need to trap error

Please Login or Register  to view this content.