sivadnitram
09-12-2008, 07:28 AM
Good Afternoon,
I am using Office 2003 and XP Home edtion. Version 2002 service pack 3
I am trying to construct a workbook to keep track of credit cards and bank account. The sheets that do all the calculations work fine. The first two sheets are named FRONT and SUMMARY. on the FRONT sheet cell A1 holds the date derived from =TODAY function and is formatted as 12-Sep. I have a recorded macro entitled PRINT which runs OK from the button entitled PRINTSHEET on the FRONT sheet. I am trying to get this macro to run whenever cell A1 holds a date which co-incides with the last day of any month. I have tried reformatting the date using =DAY(reference cell) and =Month(reference cell) the result being displayed in cell A2. I have tried to use the value in A2 to trigger the PRINT macro using:-
If Me.Range("A2").Value = ** Then
Call printsheet
End If
Which was very kindly provided by Simon Lloyd. I cannot seem to get passed the fact that different dates end up giving me identical values in A2 which makes the whole thing wobble. As a novice I expect there id a very simple solution but I cannot find it. I have consulted the excel programme help files, microsoft office online and Excel 2003 bible to try to solve this problem. If there is anybody who can help me I would be very grateful.
Sivadnitram
I am using Office 2003 and XP Home edtion. Version 2002 service pack 3
I am trying to construct a workbook to keep track of credit cards and bank account. The sheets that do all the calculations work fine. The first two sheets are named FRONT and SUMMARY. on the FRONT sheet cell A1 holds the date derived from =TODAY function and is formatted as 12-Sep. I have a recorded macro entitled PRINT which runs OK from the button entitled PRINTSHEET on the FRONT sheet. I am trying to get this macro to run whenever cell A1 holds a date which co-incides with the last day of any month. I have tried reformatting the date using =DAY(reference cell) and =Month(reference cell) the result being displayed in cell A2. I have tried to use the value in A2 to trigger the PRINT macro using:-
If Me.Range("A2").Value = ** Then
Call printsheet
End If
Which was very kindly provided by Simon Lloyd. I cannot seem to get passed the fact that different dates end up giving me identical values in A2 which makes the whole thing wobble. As a novice I expect there id a very simple solution but I cannot find it. I have consulted the excel programme help files, microsoft office online and Excel 2003 bible to try to solve this problem. If there is anybody who can help me I would be very grateful.
Sivadnitram