3 very simple macros needed

[Kim B]

Hi all. I know similiar requests have been made. I have tried to adapt the results to what I am trying to do and have had no luck so here goes.

I need a macro that will:

1. autofit all cells in 38 worksheets
2. copy the previous row without looking up or deleting or inserting. Just a simple copy previous row of values and formulas down one (to the next row empty or not)
3. Hide columns with headings hide in the first cell of the column.

Remember, I have 38 worsheets in the same workbook that it has to cycle thru. 4 of those are pivots, so no need to include those.

Thanks in advance.

 

[Kim B]

Not sure if I missed a post regarding the pivot tables macro not working. Do you know if you responded?

Thanks

 

[Smitty]

Not sure if I missed a post regarding the pivot tables macro not working. Do you know if you responded?

Sorry, I didn't get a chance on that; I've been in meetings for the past two days and I'm spending today catching up. You may want to repost that portion, so everyone can take another look.

 

[Kim B]

That's ok. I will wait. Just didn't want to miss any responses. We have been going back and forth quite a bit and I wasn't sure. I would rather stick with you. Your solutions work and I don't get the run around.