Forum Discussion
KAM_Mumin
Sep 02, 2022Brass Contributor
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...
DexterG_III
Sep 02, 2022Iron Contributor
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.
KAM_Mumin
Sep 04, 2022Brass Contributor
dear that is not working when i insert this,,, if you have another solution then plz send me,,