markshowell
Last Activity: Sep 16 '06, 08:20 AM
Joined: Sep 14 '06
Location:
-
No it does the clearing ok the error points at the range("a1").sel ect command... -
Excel - Clearing Sheet Contents
I'm trying to use the following code to clear the contents of the two worksheets named Unpaid and Payments and then locate the cell pointer for that worksheet in cell A1 -
Worksheets("Unp aid").Cells.Cle arContents
Worksheets("Unp aid").Select
Range("A1").Sel ect
Worksheets("Pay ments").Cells.C learContents
Worksheets("Pay ments").Select...
No activity results to display
Leave a comment: