I am recording a macro to automatically generate the lines of code. After I start the macro and stopped recording, I check the code. Immediately, I receive a "Syntax Error".
This was a recorded macro, why would it generate a wrong code?
The code below is exactly how it was recorded.
I have Excel 2016 in WindoWs 10.
Thank you
![]()
Sub FixFilter() ' ' FixFilter Macro ' ' Range("A1").Select ActiveSheet(, .(xlToRight)).Select ActiveSheet(, .(xlDown)).Select . ActiveSheet.Enabled := 10 .ActiveSheet("$A$1:$T$841"). Index := 20, BringToFront := "<>" Range("R545").Select End Sub
Bookmarks