+ Reply to Thread
Results 1 to 5 of 5

Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid Prope

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid Prope

    Hi guys,

    I have this code. Want to delete many wroes by doing a multifiltering.
    I receive this error.Error "Wrong Number of Arguments or Invalid Property Assignment: 'Item'"

    Pls advise
    Please Login or Register  to view this content.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid P

    I haven't tested the code without an example, but if you are only filtering column A, then would there not just be 1 field?

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid P

    i was hoping to do this in VBA by selecting multiple filter fields...lol...will not work with more than 1 field and 2 criterias

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid P

    You can use filterarray, but even with this, you can use a maximum of 2 asterisks.

  5. #5
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Can't filter with many arguments --error Error "Wrong Number of Arguments or Invalid P

    cool stuff! thank you AB33!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compile Error: Wrong number of arguments or invalid property assignment Error
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-22-2016, 05:29 PM
  2. [SOLVED] wrong number of arguments invalid or property assignment error
    By uduyt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2013, 07:40 PM
  3. [SOLVED] Compile Error: Wrong number of arguments or invalid property assignment
    By bobmaucher in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 12:41 PM
  4. Replies: 1
    Last Post: 06-07-2012, 11:38 AM
  5. wrong number of arguments invalid or property assignment error
    By uduyt in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2012, 08:39 AM
  6. Code error “wrong number of arguments or invalid property assignment”
    By hattrick_123a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2011, 06:16 PM
  7. Replies: 1
    Last Post: 02-17-2006, 12:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1