How do I get a macro to...

[dk]

You could put it in a loop like this:-

Sub DoItToAllSheets()
Dim sht As Worksheet

For Each sht In ThisWorkbook.Worksheets
    'Do something to the sheet
    sht.Cells.Columns.AutoFit
Next

End Sub

You don't say whether you're activating things (e.g. Range("A1").Select) or not so this code may not be appropriate. It's normally helpful if you post some or all of your code.

HTH,

D

 

[Audiojoe]

Sorry, I just wanted a macro that would run all the macro formulas in a workbook. They all format the info that's been pasted in each one to a presentable level

It's OK though, I got it

Thanks for your suggestion though