Code assistance Required

I am having problems executing the following code:

I have the code to loop to row 6 for now to see if it works ....row 6 has the first occurance of what I need to execute... in cell D6 the value is:

Cell D6 =(C6/1000)*Q6 and format is "currency"

does this constitue as a formula in VB because it has no stated functions?

I tried to delete the second AND condition and just leave the ISNUMERIC condition ...but this still does not execute?


This is part of the second If statement that I would like to execute based on cell D6 value

Please Login or Register  to view this content.

Here is my Procedure!

Please Login or Register  to view this content.

Any ideas! Would be much appreciated

Thanks in advance,

Hello SeenFresh,

The problem is in the ANDing. You have a condition that is ANDed with the negation of itself (highlighted in red). This prevents the AND from ever being true.
.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you Leith, your right!

my goal was to try and execute my statement if the cells in column I do not contain the subtotal formula and are numeric...

I have one more question I have fixed the code as you suggested, but the code still seems to execute when cells in Column I are blank and contain text....maybe I am missinterpreting the ISNUMERIC function... I am just desiring to execute on two condition... if cells in Column I are do not contain the Subtotal formula and are numeric (or currency) style...

Here is the code...it still execute when cells are blank and contain text...Would appreciate any further insight...Thanks a bunch!!

Please Login or Register  to view this content.