Consulting

Results 1 to 3 of 3

Thread: Help with macro for filter

  1. #1

    Smile Help with macro for filter

    Hi,
    this is my first post. I hope you can help me. I have a macro that filters data after searching. It works great but there are 2 problems:
    1. After typing for the search the macro shows a message box with following text :"Soll nach einem Datum gesucht werden?". This is not want I want. I tried to delete some lines from the code but no chance to get it work. I always got an error message. How can I delete it?
    2. The macro always opens a new sheet. I want to have the results on sheet "Filter" starting on A2

    Can you help me?
    Thanks a lot!!

    Kind Regards

    P.S. Sorry for my english.....
    Attached Files Attached Files

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    This is all very confusing. That message is about dates, there are no dates in the data, and when I put in a search term, it fails because it is trying to get a date value where there is no date.

    What are you trying to do here?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Hi xld,
    I don't need to search for a date. So i want to delete this from the code.
    I just want to search for some dara and get the results.
    I found this macro and the search function was already in the code.
    Kind Regards

Posting Permissions

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