helo i have a worksheet with a list (tabla1) first column in list contains dates
i need a code to select a initial and end date to print data from list (important needs to inlude Application.Dialogs(xlDialogPrinterSetup).Show to pront to select printer)
thank you
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
test.xlsm
i am uploading the file with the list ,
i am looking for a vba code that filters 1st column by 2 dates start and end date and print only selected dates from list
lets say i have 4 rows and 8 columns of list and i select 12/08/17 to 13/08/17
12/08/17 DATA DATA DATA DATA DATA DATA DATA
12/08/17 DATA DATA DATA DATA DATA DATA DATA
13/08/17 DATA DATA DATA DATA DATA DATA DATA
14/08/17 DATA DATA DATA DATA DATA DATA DATA
only first 3 rows of list are printed because they match criteria of selected dates
if date invalid or not match with list show error and promt again to select dates
thank you
Why do you need a macro. Why not Date Filters, Between... from the filters dropdown in column A?
Ben Van Johnson
i would add the code to a userfrom i have created ...
Surely the question is still valid though.Originally Posted by bluepomme
i would add the code to a userfrom i have created ...
Using a macro with a userform will involve just as many, maybe more keystrokes as a standard Excel Autofilter with the 'between' dates selection.
However if you do need a macro, with the dynamic range name 'dates' which covers all the dates in a column, and two text boxes on a user form, the code to run is
Please Login or Register to view this content.
thank you for your answer, help and advise
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks