I am running a macro where i have specified a loop and this line of code is a part of it:
If ActiveCell.Value >= 30 Then
This checks the cell the cursor is positioned at to check is value is >30 . My problem is that the cell being checked for >30 has a number(#NUM!) error and when this happens the macro stops executing and says "mismatch".
I was wondering if there was some way in which i could just specify in the condition that when the macro encounters (#NUM!) instead of a number to check if >30 it should ignore it and keep running?
Any suggestions?
Thank you,
Navya
If ActiveCell.Value >= 30 Then
This checks the cell the cursor is positioned at to check is value is >30 . My problem is that the cell being checked for >30 has a number(#NUM!) error and when this happens the macro stops executing and says "mismatch".
I was wondering if there was some way in which i could just specify in the condition that when the macro encounters (#NUM!) instead of a number to check if >30 it should ignore it and keep running?
Any suggestions?
Thank you,
Navya