Macro To Group Columns In Multiple Worksheets

Below is a small but powerful macro to group multiple columns in multiple worksheets in one go provided all the worksheets have same format. If worksheets have different format, you can easily modify this macro to run on a single worksheet which is the ActiveSheet by removing the for loop as shown here.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">