Hi All,
I have got a sheet that contain data of various month separated by 2 empty columns. I have got a macro that could run for a set of data, hence I need a macro to delete the older set data along with the 2 empty columns next to it and leave the next set of data alone in the same sheet.
I have attached a sample sheet with the input and output for better understanding.
Thanks in Advance!
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
Thanks for your reply! The code does delete the old month data but it deletes the data in the columns A to G too.. which shouldn't happen
Last edited by jeffreybrown; 06-03-2017 at 01:35 PM. Reason: Removed unnecessary quote!
It didn't delete A:G with your example file.Originally Posted by sarajun_88
Hi,
Thanks for your reply! The code does delete the old month data but it deletes the data in the columns A to G too.. which shouldn't happen
Give this a try...
Please Login or Register to view this content.
Thanks a lot!! This worked perfectly 😀It didn't delete A:G with your example file.
Give this a try...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks