DavidOSullivan94
New Member
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.
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.