Passing a range

[j_Southern]

Dear Forum members
The following code gives an error message "Method Range of Object_Global failed. on the line marked with*

Please Login or Register  to view this content.

I would be very grateful for advice in pointing out what is wrong.
If the variable is replaced with the range name then the code works and I get a value for p. I need the variable though for the Function will be used to
filter several tables.
John

[Andrew-R]

You've already said that TryTable is a range, so you don't need to include it inside a Range()...

Please Login or Register  to view this content.

[j_Southern]

Andrew-R
Doh ! Thanks
John