Results 1 to 17 of 17

Thread: VBA code for deleting "FALSE" functions

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-09-2021, 11:41 AM #9
    BigBill7
    BigBill7 is offline
    VBAX Regular
    Joined
    Feb 2021
    Posts
    18
    Location
    I'm getting an error 424 in the code here when trying to run any idea why? it worked before so I'm not sure what's wrong


    'copy overWith rData
    .AutoFilter Field:=14, Criteria1:="<=100"
    .SpecialCells(xlCellTypeVisible).Copy Worksheets("100 and below").Cells(1, 1)

    .AutoFilter Field:=14, Criteria1:=">100", Operator:=xlAnd, Criteria2:="<=1000"
    '.AutoFilter Field:=14, Criteria1:=">=101", Operator:=xlAnd, Criteria2:="<=1000"
    .SpecialCells(xlCellTypeVisible).Copy Worksheets("101 to 1000").Cells(1, 1)
    Last edited by BigBill7; 03-09-2021 at 11:57 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules