Not exiting For loop

I have a For loop that depends on the number of cells that have a numerical value.

I can step through the code and verify that it's not exiting the For loop when the cell value is "Empty". Can anyone help? Thanks.

Here's the block of code that appears to be giving me trouble.

Please Login or Register  to view this content.

Thanks,

-gshock

Please Login or Register  to view this content.

This if statement checks if the value is a number and if its not empty. If it is empty, it stops the for loop. Then it inserts it into your range. Which is current fixed at C14, You do realize the for statement will cause C14, to overwrite each value that is numeric and not empty.