VBA code for data on a certain date

[tlindeman]

Could you please supply VBA code for something like this: If B2<TODAY(), copy formula from A3 paste into B3. Else leave blank. I know how to write an if statement to that effect, however, for complicated reasons I need it in VBA.

Thank You
Tony

 

[MrKowz]

It looks like your condition didn't post properly. If you had a < sign or a > sign in the formula, be sure to put a space before and after it, so the HTML compatability of the forums don't mess it up.

Eg:

If B2 < Today Then DoThis

 

[tlindeman]

Sorry, Here is the code I would like:

IF B2 < Today then copy A3 Paste B3. Else Blank. I have a formula in A3 that I need to copy and paste on certain dates, I know how to do this with an if statement, however, I need it in VBA.

Thank You
Tony