Lunker55,
Amalgamate you macros.
Assume that the first macro is called Save and the second macro is called
clearform. Assume that you want to run CLEARFORM after SAVE do the following:-
Just before the END SUB in SAVE type CLEARFORM
HTH
Pank
"lunker55" wrote:
I have two macros. I would like to press 1 macro button that will do both
macros.
Is there a way to do this?
Macros are below,
Joe
Sub SaveAsCellString()
ActiveWorkbook.SaveAs Filename:= _
"C:\shipway\invoices\" & Range("E5").Formula,
FileFormat:=xlExcel9795, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub
Sub clearform()
'
' clearform Macro
' Macro recorded 20/06/2005 by Joe Clarkson
'
'
Range("A16:C28").Select
Selection.ClearContents
Range("E8").Select
Selection.ClearContents
End Sub
|