• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Generic Advance Filter

K

kchiba

Active Member
I am not sure if this is the place to post this, but attached is a file that will help with Advance Filter.

The VBA, in this case stands for Very Basic, but it works (I hope).

regards

kanti
 

Attachments

  • generic_advFilt.xlsm
    27.3 KB · Views: 5
Hi Kanti ,

Thanks for uploading.

Can you modify the following lines , so that instead of clearing the target sheet in toto , it clears only a range which starts at the start cell , and is sized based on the number of rows and columns in the full data table ? This way , we will not be restricted to having the destination range on a separate sheet all by itself.

Cells.Select
Selection.ClearContents

Narayan
 
You must log in or register to reply here.
Back
Top