apply macros to multiple worksheets

dom13 · dom13's Computer Specifications

hi
i am trying to apply a macro that i recorded to all worksheets within a workbook. here it, how do i go about, i have seen other posts and just can't seem to get it to work.
any help appreciated.

Sub format()
'
' format Macro
'
'
Rows("1:2").Select
Range("K1").Activate
ActiveWindow.SmallScroll Down:=21
ActiveWindow.LargeScroll Down:=-1
Selection.Delete Shift:=xlUp
Columns("E:E").ColumnWidth = 10.43
Columns("E:E").Select
Selection.Delete Shift:=xlToLeft
Columns("G:G").ColumnWidth = 7.57
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
Columns("J:J").ColumnWidth = 11.86
Columns("J:J").Select
Selection.Delete Shift:=xlToLeft
Columns("K:K").ColumnWidth = 7.29
Columns("K:K").Select
Selection.Delete Shift:=xlToLeft
End Sub

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Apply maco to multiple worksheets request	joecrabtree	Microsoft Excel Programming	3	24th Mar 2009 11:15 AM
How to apply a filter to multiple worksheets	=?Utf-8?B?SmltQFRlY2g=?=	Microsoft Excel Discussion	1	18th Apr 2006 06:11 PM
Need to apply VBA code to multiple Worksheets	parteegolfer	Microsoft Excel Programming	2	12th Mar 2006 08:43 PM
Apply Macro on Multiple Worksheets in a Workbook	Agnes	Microsoft Excel Programming	0	24th Sep 2004 01:39 AM
Apply Macro on Multiple Worksheets in a Workbook	Agnes	Microsoft Excel Programming	1	23rd Sep 2004 02:20 AM