I need some input from you smart folks. I am populating an excel spreadsheet. Each time, I want to clear the spreadsheet content before repopulating it. I am using the codes below and it is clearing the first 3 rows in the spreadsheet and every other data stays in tact.
This is is my code:
xlWksht.Activate 'xlWksht.Range("A1").Activate xlApp.Selection.CurrentRegion.Select xlApp.Selection.ClearContents
Any help will be appreciated.