Hey guys
I have a short macro that I want to run once per year on a specific date.
Specifically, I want to update the year column at the beginning of of each new fiscal year, which for me happens to be today July 1st.
Here's the macro
Just looking around here I've seen use of the wait command and such, but I'm looking for an arbitrary date reference if possible, rather than one that references the current time.
As a second question, I'd like this macro to run continuously, such that each time the workbook is opened the macro runs a check to see if the right date has been reached.
Also, I'd like a macro to automatically update cells based on data entered by the user, I was thinking I could adapt the answer to the previous question to fit this as well.
Thanks a lot guys you've been great so far
Mike
I have a short macro that I want to run once per year on a specific date.
Specifically, I want to update the year column at the beginning of of each new fiscal year, which for me happens to be today July 1st.
Here's the macro
Code:
Sub Dates()
Worksheets("Sheet1").Range("D1:D1").Delete Shift:=xlShiftToLeft
End Sub
Just looking around here I've seen use of the wait command and such, but I'm looking for an arbitrary date reference if possible, rather than one that references the current time.
As a second question, I'd like this macro to run continuously, such that each time the workbook is opened the macro runs a check to see if the right date has been reached.
Also, I'd like a macro to automatically update cells based on data entered by the user, I was thinking I could adapt the answer to the previous question to fit this as well.
Thanks a lot guys you've been great so far
Mike