VBA Error Thrown

[DavidOSullivan94]

Hi,

The Snippet runs perfectly in excel but when pasted into the Code section of the Code box properties; it throws an error.
It requires the 'method argument' to be in parentheses. This is unusual as the VB syntax doesn't follow this requirement.
======
GetInstance(handle).Range("$A$1:$X$114506"). _
AutoFilter Field:=10, _
Criteria1:="27/01/2020"
======

I've managed to narrow the issue down to line two.
The idea, at a later date would be for the criteria, range, and auto-filter field to take inputs from the process.

I've tried to incorporate parentheses at various stages on the second line but to no avail.

 

[DavidOSullivan94]

I've rectified the filtering error but the issue is now 'End of statement expected '
The code has changed slightly to as follows;
================================
GetInstance(handle).Range("$A$1:$X$114506"). _
AutoFilter(Field:=10), _
Criteria1:="27/01/2020" _
=================================

Any Idea's

 

[DavidOSullivan94]

Fixed.
Solution:
Make sure to put all parameters inside the functions parentheses.
Code below will filter the range highlighted, by the 10th column with the constraint of the date.
To make the VB dynamic, include input parameters from the process.
===
GetInstance(handle).Range("$A$1:$X$114506"). _
AutoFilter(Field:=10,Criteria1:="27/01/2020")
==