When I try to run my macro that uses advanced filter it works fine, until I
try to share the workbook. When I share the workbook I receive the following
error

Run-Time error 1004 AdvancedFilter method of range class failed.



Thanks for nay help

I don't think that "Advanced Filter" is available in shared mode.
Check DataFilter to see if 'Advanced Filter' is greyed out.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"ram" wrote:

When I try to run my macro that uses advanced filter it works fine, until I
try to share the workbook. When I share the workbook I receive the following
error

Run-Time error 1004 AdvancedFilter method of range class failed.



Thanks for nay help

Hi Gary,
I agree with you, so I have been trying to hide rows based on the criteria
as a work around. Bob Philips provided code to accomplish this however when
there are a lot of rows it runs a little slow.

Thanks for your time

"Gary L Brown" wrote:

I don't think that "Advanced Filter" is available in shared mode.
Check DataFilter to see if 'Advanced Filter' is greyed out.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"ram" wrote:

When I try to run my macro that uses advanced filter it works fine, until I
try to share the workbook. When I share the workbook I receive the following
error

Run-Time error 1004 AdvancedFilter method of range class failed.



Thanks for nay help