Hi,

I'm looking for a foolproof way of identify empty cells within VBA code.
For example I've written code that extracts the first two digits from a
postcode but the code fails when I encounter an empty cell. I've tried
building in If statements with isempty, isblank and Null and " " but its
doesn't seem to work 100% of the time. Any suggestions would be greatly
appreciated.

Regards

David