autofilter vba

  1. D

    VBA Creating Named Tables in multiple sheets in new workbook

    Hi, i have some code that a) filters data from the table in one sheet into a group of new sheets named by the filter value b) creates a new workbook from these sheets The script does the above. The additional code has no effect that i can see. It doesnt stop it working, it just doesnt do...
  2. C

    Applying autofilter then copying the sheets in a summary sheet from an excel workbook

    I am trying to apply autofilter and then copy the filtered results in one sheets using the below code . But it is throwing an "Object Variable not set error " Please help Code Sub CopyDataWithoutHeaders() Dim ws As Worksheet, DestSh As Worksheet, Rng As Range Set DestSh =...

Some videos you may like

This Week's Hot Topics