|First, a posting tip:|
Try tossing in some punctuation and capitalization every now and then. When you post one long "sentence" with no periods it makes your post very hard to read.
If you are sure that the cell is blank, then you can force a blank to be returned with this formula:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.