Need a code to remove empty columns (similiar to removing empty rows)

[amanbareilly]

Hi All,

I am searching for VBA code to delete all empty columns from a collection which works similar to removing empty rows action.

 

[naveedraza]

take a copy of "Remove Empty Rows" action page in "Utility - Collection Manipulation" VBO and rename to remove empty columns and in code tab
clear all the code and enter attached code in it and run it...