I have created a user form that gets used at the end of the month to print and save the data. What I want to happen is when you open the form you have a start date and an end date and choosing this will select all the data between those two dates and set it as the print range so the workbook can print that data (as well as the headers) and then save the selection as a PDF. The data starts in column B (2) and goes to column I (9) and the dates can be found in column C (3).
It is using the date picker object...
Here is what I have so far, although I am very stuck on the data range part.
This is also posted on Ozgrid http://www.ozgrid.com/forum/showthread.php?t=191951 however, it has gotten no response.
Bookmarks