Hi all, I have the following code for clearing all data on currently selected row but wish to incorporate 2 variables which
are both time cells and have each referenced to a third cell ($Y$1) (THIRD VARIABLE) which is an absolute time reference cell in my code.

I'd like my code to exit sub if either of my two variables is less than the current time.

The two variables in question need to be drawn from columns (F) and (J) respectively and compared to cell ($Y$1)

For example if row 35 is selected and I run my macro, if the value of $Y$1 is greater than "either" F35 or J35 than my code finishes and exits sub....
If F35 AND J35 both are greater than $Y$1 than my code can run as per normal and the row contents are cleared...

ANY HELP GREATLY APPRECIATED.


Sub CLEARROW()


Sheets("myBoard").Unprotect
Selection.EntireRow.ClearContents
Sheets("myBoard").Protect

End Sub