Thread: [Solved] Schedule Converging
View Single Post
 
Old 06-01-2015, 10:44 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

To clear Master: At the beginning of the first macro, between
Application.ScreenUpdating = False
and
'create scratchpad worksheet

add this
Code:
With Sheets("Master")
    .Range(.Range("A1"), .UsedRange).Offset(1, 0).Delete Shift:=xlToLeft
End With
Quote:
This has saved my company a lot of money on more expensive alternatives.
Does that mean we get a raise?
Reply With Quote