Macro I can add to the end of my pasting macro That will hide Column A on all tabs

[Johnny Thunder]

Hello All,


I have a running macro that copies/Paste data from "Report_Paste" tab to about 12 tabs, at the end of the macro I would like the last piece of the script to say Hide Coulmn A from all tabs except the "Report_Paste" tab. Any ideas?

I use the record macro button to record the code and highlight all tabs and then hide column A but it only seems to hide it in one specific tab?

I am using Excel 2007

 

[Mike Blackman]

Hi,

Maybe something like this;

    Dim ws As Worksheet
    
    For Each ws In ThisWorkbook.Worksheets
        ws.Columns("A").Hidden = True
    Next ws

Place the Dim at the top of your sub and the rest at the bottom.

 

[Johnny Thunder]

Hey Mike,

The code worked great! Thanks!


Now you have sparked a new question, I am going to write another post but I will write it her as well.

I need a macro to put at the end of the code you just gave me that will look through all tabs and go to column F and go down to the last cell with data and do an auto sum upwards to F3 and copy this formula (Sum) along the last line of data all the way to Column Q. Any ideas?