Macro stops when encounters #VALUE!

Originally Posted by :) Sixthsense :)

Where do you have #Value error in your workbook?

Hi sixthsense,

Sorry i just uploaded another file which im using to run the macro in.

Kind Regards,
Mark.

Originally Posted by :) Sixthsense :)

Still I don't find the #Value error in that new workbook also

Hi Sixthsense,

I might be wrong here im sorry but whenever i open the test file and run the macro from the macro file, it stops halfway and i'm assuming its because of the value #VALUE# in column H4. I only run the macro called CREATE.

Kind Regards,
Mark.

Originally Posted by :) Sixthsense :)

Use IsNumeric() to check whether it is number and proceed further

Please Login or Register  to view this content.

Hi Sixth Sense,

Sorry im not really sure on how to do this as this macro was done by someone else.
Is there anyway to help me to put this in the macro file?

Kind Regards,
Mark.

Originally Posted by mark888

Hi Sixth Sense,

Sorry im not really sure on how to do this as this macro was done by someone else.
Is there anyway to help me to put this in the macro file?

Kind Regards,
Mark.

Hi SixthSense,

Tried to change myself the macro code but it still doesnt work.

Kind Regards,
Mark.

Originally Posted by davesexcel

Could you use this in Column H?

Formula:

Please Login or Register  to view this content.

Hi Dave,

I tried SixthSense and edited all the values in the Macro itself and it's working now. Don;t want ot be too confused with formulas.
Thanks you both of you for your time and expertise.

Kind Regards,
Mark.