How To Split An Excel File Into Multiple Files Using VBA (Formula Retained) | Excel Automation

I am getting an error with .AutoFilter.Range("C1").Column, Category_Name
AutoFilter method of Range class failed? Error 1004

Very new to VBA, any insight would be really helpful

Thanks a lot, you have saved me lot's of time
I have an error but I'll try to work around it

Hi. I get a compile error “argument not optional” when I debug on the line col.Add.Cells(RowNumber, “A”).Value, CStr(.Cells(RowNumber,”A”).Value). Is this supposed to happen and how do I fix it?

Excellent work 👍

for a good vision you need to zoom the video dear. i can't see nothing

Could u pls make a video on highlight active row using VBA? Not only in a specific excel file. Each n every excel we open, the macro should be active.. Pls