Forum Discussion
MS Excel VBA
Hi Everyone! Here I want to take the values of the Remarks column from the sheet name "AS cs S" to any cell like G3 of the sheet name "AS Sanitary" but here some conditions I apply which are: 1. Fi...
KAM_Mumin If I understand correctly, all cells are being cleared after the filter is applied. And therefore, nothing remains to be copied in subsequent steps.
In your code, just before selection.clearcontents,
insert Selection.SpecialCells(xlCellTypeVisible).Select.
This will ensure that only the cells not being filtered will be cleared.
Hope this helps.
dear that is not working when i insert this,,, if you have another solution then plz send me,,