I am having trouble deleting all the rows within a table. I have a table with an indefinite amount of rows of data. I want to select the table and delete all the rows of data in order to replace it with another indefinite amount of data. Here is the macro I recorded but it only deletes the first row. Any ideas?
Thank you!
Nicole
Code:
Sub Macro2()
'
' Macro2 Macro
'
'
Range("Table8[A]").Select
Selection.ListObject.ListRows(1).Delete
End Sub
Thank you!
Nicole