Getting VBA IF statement to behave correctly with =TODAY()

Greetings Excel Forum,

I am pretty new to using IF statements within VBA, and i'm having a hell of a time trying to get the one i've written to work correctly.

I am trying to get the formula to perform the "Update Current Date" portion of my code to trigger if the first column in the last row is equal to today's date (so as to update the everchanging data of today's data located in "Summary" sheet.)

Please Login or Register  to view this content.

However, statement is coming back as false even if the first column of the last row is today's date (perhaps VBA doesnt like comparing formula answers to hardcoded answers?).

Hi Dylan87,

I put "=TODAY()" in the last cell in Column 'A'.

The following code worked fine for me (as cut and paste from your sample macro):

Please Login or Register  to view this content.

The following may help you debug:
Debugger Secrets:
a. Press 'F8' to single step (goes into subroutines and functions).
b. Press SHIFT 'F8' to single step OVER subroutines and functions.
c. Press CTRL 'F8' to stop at the line where the cursor is.
d. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.
e. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'debug.print' statements send their
output to the IMMEDIATE WINDOW.
f. Select View > Locals to see all variables while debugging.
g. To automatically set a BREAKPOINT at a certain location put in the line:
'Debug.Assert False'
h. To conditionally set a BREAKPOINT at a certain location put in lines similar to:
if i >= 20 and xTV20 > 99.56 then
Debug.Assert False
endif
i. A variable value will be displayed by putting the cursor over the variable name.

If you need additional help, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Lewis

Hi LJMetzger,

Thank you for relplying with your feedback. I'm going to be honest with you, im not sure i'm clever enough to figure out what breakpoints are or how they are meant to be used.

That being said, i managed to work out a solution to my issue. Turns out you can use DATE instead of trying to formulate todays date with =Today().

So i changed this line:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

And the script now does what i need it to do. Thank you all the same though!

Dylan.