sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,380
- Office Version
-
- 2016
- Platform
-
- Windows
Using the following, is there a way I can clear the contents of the source data after importing it?
Code:
Sub GetData_Example3()
' In this example Header = False and UseHeaderRow can be True or False because it is not used
GetData ThisWorkbook.Path & "\test.xls", "Sheet1", _
"A2:C4", Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1), False, False
End Sub