I have a userform that prints a monthly report from a commandbutton. This is picked from the sheet where the userform send the data to. This sheet is designed to run for multiple years. At the moment the command button prints the month but this is because this is the first year of operation.
Is it possible to code in the month and year plus 14 days to allow time to print the last month?
This is the current code:
HTML Code:
You don't explain how the date correlates to your code. I assume it has something to do with copying column I?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
The Data sheet will contain dated entries over a period of years. The command buttons the print the monthly reports works but I need the code to only print a month report for a particular year. as it is set up, it will pick up, say March, for all of the years entries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks