Dear all,
I am facing an problem in deleting the range.
I have Columns A:D. I have filtered Column D with a Value and deleting cell under Column C:D.
I want to delete the values under column C:D and move the cells up after deletion.
But when i delete this filtered range using VBA code Selection.Delete Shift:=xlUp, it deletes all the values under column A:D and then moves it up.
Is there any way to retain the values under A:B column and delete the values under C:D and move them up.?
Please note: Data is filtered and then deleted.
Thanks for any help.
Bookmarks