Blank cell gives error 13 (Mismatch) in loop - edit code to accommodate for blanks

Hi guys,

I hope you can help me.

I have a procedure that loops through a range of cells, updating my spreadsheet with the required data. But when one of my cells is blank in my range, I get an error. How can I edit my code to not see my blank cell as an error? Just moves on?

Note: I have underlined the part in the code where the loop starts.

Please Login or Register  to view this content.

Thank you in advance!

Where do you actually get the error?

Hi John,

Thank you for the responce.

I have tried it like this:

Please Login or Register  to view this content.

But get the same error.

i have also tried it as:

Please Login or Register  to view this content.

Also the same error....

Am I putting it in the right place?

Originally Posted by Norie

Where do you actually get the error?

Hi Norie,

I believe the error occurs when the loop compares my destination cell with my source cells, and where this destination cell is blank. The loop moves down in my range of destination cells with the "next Dcell" method, and when one of these Dcell are empty, I get the error.

Hope it makes sense!

I don't see how that would cause a type mismatch.

Can you identify which line of code the error actually occurs on?

I have found my mistake.....

I had my Zero (0) values formatted to show as blanks in my custom format: 0;-0;;@

Therefore this did not work:

Please Login or Register  to view this content.

Thank you all!