VBA: Remove Table without Removing Data

[meghandc]

I receive my spreadsheets in table form. I can manually by converting to range but I am wondering if there's code to remove a table without removing any of the entries within?

 

[davesexcel]

When you convert it to a range do you loose the data?

 

[meghandc]

Nope, all the data is saved. I just can't figure out how my include in my script: "convert entire table to range".

 

[JoeMo]

See: VBA to convert table to range

 

[meghandc]

See: VBA to convert table to range

Great, thank you!

 

[JoeMo]

Great, thank you!

You are welcome - thanks for the reply.