Macro for deleting all rows in table

nicolewh

Well-known Member
Joined
Aug 7, 2009
Messages
554
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?

Code:
Sub Macro2()
'
' Macro2 Macro
'

'
    Range("Table8[A]").Select
Selection.ListObject.ListRows(1).Delete
End Sub

Thank you!

Nicole
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Perhaps:

Code:
Selection.Cells(1).CurrentRange.EntireRow.Delete

Place your cursor in the tab. Please test this on a COPY OF YOUR FILE.
 
Upvote 0
Just figured it out - I feel really good about myself :). I adjusted your code and came up with this:
Code:
Sub Macro2()
'
' Macro2 Macro
'

'
    Range("Table8[A]").Select
Selection.EntireRow.Delete
End Sub

Thanks
Nicole
 
Last edited:
Upvote 0
Well done!

But this is sufficient:

Code:
Sub Macro2()
    Range("Table8[A]").EntireRow.Delete
End Sub

Select's only (marginally) slow down macro execution.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top