• Hot Topics

Excel Help with CriteriaRange in VBA .AdvancedFilter Method

. Hi senior ?Colleagues?!, . . One way I am learning my Excel / VBA is by answering Threads here. . I answered one with both a Formula and a VBA Code. The code was much too complicated As I was not yet familiar enough with the method I expect is the best, the VBA Advanced Filter Method. Particularly I do not have the experience yet in getting the correct CriteriaRange . can someone help? . So, a simplified example.. I start with this. Using Excel 2007 - 1 2 3 4 5 6 7 8 JL DataAdvFilt ????? . And wot I finally want is this. Using Excel 2007 - 1 2 3

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of May 28, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy