Hi All,
Can you please correct below codes and provide me a right approach for AutoFilter SpecialCells(xlCellTypeVisible)??
Problem: - The below codes are just working fine for me when the auto-filtered data is copied and pasted to a new worksheet, but I want to use the 'Cut and Paste' methodology instead of that.
Please Login or Register to view this content.
Here I have tried with below codes to get the output as per the above description and codes. Later, in the last....This deletes the copied cells's entire row
Please Login or Register to view this content.
...but I know it is not a good way. Please help me out to get a smart way for applying CUT and PASTE methodology on the filtered data/ cells (AutoFilter.Range.SpecialCells(xlCellTypeVisible)).
Please find the attached for better understanding:
MS Excel Version: 2007
Thanks in Advance!
Bookmarks