Forum Discussion
Excel Macro won't sort date colum
I'm trying to create a macro to sort and clean up data I import into excel that includes dates, amounts, and text fields. When I record the macro, I sort the date column from oldest to newest, but w...
Hi,
In which column date is and specify the range or put screenshot of data or paste that macro / error.
Thank you for your response. The date is in column A. I've attached screen shots of the error message and the dbug information. Hope this helps.
Hi madelyn cole
Make sure that sheet name specified in code "bk_download" matches with the sheet name you are running. May be sheet name changed or contains extra spaces.