Hello everyone,
I need your help please. I'm trying to copy and paste the result of dates search from the 'payment' worksheet to another worksheet. Below is the code I wrote but somehow I got the mismatch error on the highlighted lines below. I'm sure there is a better way of doing this but I thought this would just do what I'm aiming to fulfil.
The from date will be always in this format 01/mm/yyyy and the to date will be the last day on the selected month for that year, to which the endDate will then be the to Date +1 day.
Agent will choose the start date and end date from the userform.
Your help is much appreciated. Thank you
Bookmarks