VBA-Delete a table

[smund]

Please, How to delete a Table in VBA?

 

[Peter_SSs]

You have given very little information. If this does not help you to do what you want you would need to post back with more information about what you have and what you are trying to do, including at least ..

1. What Excel version?

2. By 'delete a Table' do you mean ..

a) Convert the table back to an ordinary range so the data remains but it is no longrer treated as a Table?

b) Delete the values from the table?

c) Something else?

 

[smund]

Thanks,

Excel 2010


Yes, I want to convert the table back to an ordinary range so the data remains but it is no longer treated as a Table, or delete a table.

The table was created like this:

ActiveSheet.ListObjects.Add(xlSrcRange, Range("$G$5:$K$" & LinhaFinal + 1), , xlNo).Name = TabelaPacientes

 

[Peter_SSs]

Try

ActiveSheet.ListObjects(TabelaPacientes).Unlist

 

[smund]

Thanks.

Very simple, but so much important.