setting variables for 2 cells on active selected row

**wanty** · 12-15-2013, 04:42 PM

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.

Please Login or Register  to view this content.

**TMS** · 12-15-2013, 05:01 PM

Please Login or Register  to view this content.

Regards, TMS

**wanty** · 12-15-2013, 05:35 PM

Thanks TM, it worked a treat, you have yourself a ripper day

**TMS** · 12-15-2013, 06:00 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.