Link to home
Start Free TrialLog in
Avatar of DRRAM
DRRAM

asked on

Macro O365

Hello,

Please I have the Following macro excel :

ActiveSheet.Range("$K$4:$KP$4").AutoFilter Field:=", Criteria3:="Coller"

it has working in excel 2010 but it has stop working when I migrated to Excel in Office 365.

Please do you have any idea ?
Avatar of Kimputer
Kimputer

Depends on where the typo is, because the syntax is:

Not
Field:="

Open in new window

but
Field:=""

Open in new window


If the typo is only here (and not in Excel), then it's a bit weird). Let us know what happens when you step into it with the debugger.
Avatar of DRRAM

ASKER

the correct command is :
ActiveSheet.Range("$K$4:$KP$4").AutoFilter Field:=3, Criteria3:="Coller"
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Pleased to help.