• How to tweak "SpecialCells(xlLastCell) command standard Excel Macro in VBA ?

    Adan Member October 6, 2015 at 11:47 am

    How to tweak “SpecialCells(xlLastCell) command standard Excel Macro in VBA ?

    #7984
  • ShikhaTan Member October 6, 2015 at 11:48 am 
    ActiveSheet.AutoFilterMode = 0
ActiveSheet.Range("A1:G20000").AutoFilter Field:=3, Criteria1:=Array("9484098260", "9480008267"), Operator:=xlFilterValues
    Range("A1:F20000").SpecialCells(xlCellTypeVisible).Copy
    #7985
Viewing 1 reply thread
  • You must be logged in to reply to this topic.