Excel macro - Used range and clear the content

Post Reply
wwj
Posts: 2497
Joined: 27 Jan 2007 08:16

Excel macro - Used range and clear the content

Post by wwj »

Code: Select all


Worksheets("Sheet1").Activate 
ActiveSheet.UsedRange.Select


' Clear the content
    Sheets(outSht).UsedRange.Select
    Selection.ClearContents
Top
Post Reply

Return to “Excel & Macros”