need assistance with VBA language for blank cells in an If statement

[DFrank231]

I am running code that iterates a formula starting in cell V2 through a variable 'n' that is defined by the number of constants in an adjacent column. The excel formula i am trying to copy down is as follows: =IF(OR(BG2="",BH2=""),"No","Yes")
BG2 and BH2 are dates if it matters. basically, if either of those cells are blank, the returning value is no. if they both have values, return yes.

this is the code i am trying to use:

Please Login or Register  to view this content.

i get a runtime 1004 application defined or object defined error. all variables are defined. i think it has something to do with isblank. i have tried using """" as well for a blank status and i get the same error.

Can anyone help with a work around?

[rvasquez]

Are you trying to loop through cells?

[DFrank231]

yes. the loop works on other formulas, i am just having trouble with coming up with a formula that detects if these two cells 37/38 columns to the right of the current active cell are empty

[rvasquez]

This would be a string to check if they are both empty

Please Login or Register  to view this content.

[DFrank231]

Thanks for the help rvasquez. your response led me down the right path. for anyone searching this topic, this is the end code i used to make my request work:

Please Login or Register  to view this content.