[VBA] - Hide Column in All Worksheet and Sum of a Column in all worksheet

[rsolanki]

Hello All,

How can i hide a column in all sheet of excel through VBA

How can i Sum a values of whole column in all sheets of excel through VBA?

Look forward to hear your suggestion

Thanks and regards,

 

[Joe4]

You can get the code to hide a column or sum a column simply by turning on your Macro Recorder, and record yourself performing those steps manually on one of your sheets.
Then stop your Macro Recorder, and you will have the VBA to do that on one sheet. Then, simply drop that code in a VBA loop that looks through all sheets.
Here is a link to a past post that shows you how to loop through all the sheets in your workbook: VBA Loop through All Sheets Except Sheet1

Give it a shot, and see how far you get. If you need help, post back to this ticket with the code you put together, and we can help you make any necessary adjustments to it.