Schedule Converging

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Schedule Converging

06-01-2015, 10:44 PM

NoSparks

Windows 7 64bit Schedule Converging

Office 2010 32bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 831

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?

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Daily Loan Tracking schedule	pranjal	Excel	1	12-04-2014 11:57 AM
what to put in to schedule for dealing with overall finish date	ketanco	Project	7	10-30-2014 02:25 PM
showing fabrication items in schedule	ketanco	Project	4	06-24-2014 12:18 PM
Getting Error when I schedule a meeting in outlook	ms3433	Outlook	1	09-05-2013 11:03 AM
Powerpoint project schedule	L J Keane	Project	0	09-14-2010 01:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:13 PM.