Hi,
After I have applied a number of filters on an excel spreadsheet using vba, how can I remove/delete the data that is NOT Visible. I know the below code will select ALL visible cells but is there a way to amend this code to delete all non visible.
Range("A2:A" & Range("AY65536").End(xlUp).Row).SpecialCells(xlCellTypeVisible)
After I have applied a number of filters on an excel spreadsheet using vba, how can I remove/delete the data that is NOT Visible. I know the below code will select ALL visible cells but is there a way to amend this code to delete all non visible.
Range("A2:A" & Range("AY65536").End(xlUp).Row).SpecialCells(xlCellTypeVisible)