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