Need help on Macros

[hitesh222002]

Hello there,

I've attached a macro file in this email. It is about automating sales report for 3 different weeks. The macro is supposed to run for 1st, 2nd and 3rd week. However, Iam unable to run the macro for 2nd and 3rd week.

I've recorded the macro for the 1st week. However, when I try to automate the same for 2nd and 3rd week, It shows runtime error '1004'. The debugger is showing the error as .Color = -16383844 highlighted in yellow in the VB page.

Do I need to make any changes in the code to make the macro run for 2nd and 3rd week.

Even the conditional formatting for 'Charged Off' is not reflecting for the 2nd and 3rd weeks.

Looking forward to hearing from you guys.

 

[hitesh222002]

Iam unable to upload Macro enabled file using the 'Upload Image' tab. It is only accepting .jpg and few other extension. This is a macro excel file. Please guide me as to how can I upload the file