Hi, I need advice about combining many small macros into one macro. Below are 3 macros that basically do the same thing on different sheets - I have a total of 11 of these macros for 11 sheets. Would it be wiser to combine them into one macro? Right now I have a macro that calls all of them. If so, would I be using the "activate" sheet method or is their a better way. If you could giveme an example on these 3 then I could apply to the rest. Thanks for the help.
VBA Code:
Sub CLUTCH_BUILD_ERASEROW()
Application.ScreenUpdating = False
Sheets("CLUTCH").Activate
Range("A32:S5000").Clear
Range("A25").Select
End Sub
VBA Code:
Sub CUTTER_PROD_ERASEROW()
Application.ScreenUpdating = False
Sheets("CUTTER").Activate
Range("A25:Z5000").Clear
Range("A20").Select
End Sub
VBA Code:
Sub DETAIL_FORM_ERASEROW()
Application.ScreenUpdating = False
Sheets("DETAIL FORM").Activate
Range("A31:AE5000").Clear
Range("A31:AE5000").Interior.color = xlNone
Range("A11").Select
End Sub