Consulting

Results 1 to 3 of 3

Thread: Clear all except first row

  1. #1
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location

    Clear all except first row

    In sheet1 I search a company and click the top button to get a filterd list of invoices for that company on sheet"Filtered"
    BUT in need to leave the command button in row1 on sheet "Filtered" alone ... in other words the clearing of sheet "Filtered" needs to start on the second row of that sheet .

    The way it is set up now I delete the command button when I filter on sheet1

    Thank you
    Thank you for your help

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Like this?
    Semper in excretia sumus; solum profundum variat.

  3. #3
    VBAX Mentor
    Joined
    Sep 2004
    Posts
    431
    Location
    Exactly like that..
    Many thanks paulked
    .... is the "solved" option down?
    Thank you for your help

Posting Permissions

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