Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Clear a full Worksheet in Excel
- Thread starter lb1
- Start date
- Thread starter
- #3
Use res.Clear or if you want to retain formatting use res.ClearContents.
Sheets("2"
refers to a sheet named 2 (not the second sheets in the sheets collection. If youe working with the second sheet use Sheets(2), or better still use the actual name of the sheet, just in case the sheets get re-ordered.
A.C.
Sheets("2"
refers to a sheet named 2 (not the second sheets in the sheets collection. If youe working with the second sheet use Sheets(2), or better still use the actual name of the sheet, just in case the sheets get re-ordered.A.C.
SkipVought
Programmer
lb1,
You can use ANY worksheet Object with the Clear method. Does not need to be the ActiveSheet...
faq707-4105 How Can I Make My Code Run Faster?
Skip,
Skip@TheOfficeExperts.com
You can use ANY worksheet Object with the Clear method. Does not need to be the ActiveSheet...
Code:
AnySheetObject.ClearSkip,
Skip@TheOfficeExperts.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question