Compile error when calling function in sub

[g8r777]

I have written the following Function to scroll through each row in a column searching for a particular value. If that value is found then the row is left alone. If the row contains anything else then delete the entire row.

Please Login or Register  to view this content.

I have tried to call the Function in the following code. When I do, I get a "Compile error: Expected: =" as soon as I even type the code. I have highlighted the code in question in red.

Please Login or Register  to view this content.

Can anyone shed some light on what the issue is and how to possibly solve it?

Thank you,

Brian

[mike7952]

Try removing the ( )

Please Login or Register  to view this content.

[g8r777]

That worked. I have other functions where you do include the ( ) when passing variables to the function. I'm not sure I understand when the parentheses are required/optional and when they aren't

[mike7952]

You need to include the ( ) when calling a function that returns a value/string/range or something to assign the returned value to a variable.