vba visible selection

  1. H

    Copy Visible Cells after filter if no data don't copy

    Hi Team, I know this is something can get it online but I could not get it and leads to lots of confusion. I need help in copying visible cells. For Example I have columns from A to AE and want to filter something on column AE and code should select only visible cells post filtered and copy...
  2. mole999

    Can't see the wood for the trees

    I have something that's driving me bonkers Sub PrepareData() Sheets("MasterData").Select Rows("1:1").Select Selection.AutoFilter '** Routines to delete large unecessary portions of file, i.e, wrong area Selection.AutoFilter Field:=1, Criteria1:="CAC" Range("A1").Select AA =...

Some videos you may like

This Week's Hot Topics

Top