Filtering Macro

Hi,

My macro selects the data (date between last month) for last month, however as I rerun the macro in next month, i have to change the code, Can you create such code which gets automatically updated as per the date.

Note: I run the macro 1st of each month so I need to filter the data for last month.

Thanks!
Sandeep