Advance filter with Application.InputBox to set CriteriaRange

**logo** · 01-05-2010, 09:22 AM

Hi
I am a beginner in VBA and would appreciate some help with this.
I get run time error 1004 method range of object global failed.

I would like to use prompt box to select criteria range.

Please Login or Register  to view this content.

Thanks!

**romperstomper** · 01-05-2010, 09:25 AM

MyRange is a Range object, so you don't use Range(MyRange):

Please Login or Register  to view this content.

**logo** · 01-05-2010, 09:33 AM

I did try that and still get 1004 error.

**romperstomper** · 01-05-2010, 09:40 AM

Assuming you selected at least two rows, and a valid criteria range, the code needs a small alteration anyway in case of not selecting anything:

Please Login or Register  to view this content.

If that still doesn't work, I'd need a sample workbook.

**logo** · 01-05-2010, 10:18 AM

Thanks for your help!

Code is OK, it turns out that I am blind as PB col is out of worksheet range.
My apologies!

Advance filter with Application.InputBox to set CriteriaRange

LinkBack

Thread Tools

Rate This Thread

Display

Advance filter with Application.InputBox to set CriteriaRange

Re: Advance filter with Application.InputBox to set CriteriaRange

Re: Advance filter with Application.InputBox to set CriteriaRange

Re: Advance filter with Application.InputBox to set CriteriaRange

Re: Advance filter with Application.InputBox to set CriteriaRange

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions