I would like to create a Macro that checkes if there is 4 times the same value in column B.
If 4 times the same value is found than those columns should be removed. Hope this is possible
I created a example in attachment
I would like to create a Macro that checkes if there is 4 times the same value in column B.
If 4 times the same value is found than those columns should be removed. Hope this is possible
I created a example in attachment
Last edited by keis386; 11-15-2013 at 05:54 AM.
Should the 4 values the same be consecutive?
Yes they are always consecutive
![]()
Please Login or Register to view this content.
Thanks a lot it is working great.
Is it also possible to add a message box that will popup and asks do you want to delete these columns yes or no
(also with action: yes delete the columns and no do not delete the columns)
![]()
Please Login or Register to view this content.
Much Appreciated for your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks