Delete any data/table exists in a given range.

[inddon]

Hello There,

I have a given range (eg. C10:G40) where the data will be pasted. Before I could do that I am checking if that given range is empty/available. If yes then paste the data.
If the given range is not empty then I would like to do delete the data:

1.If there are any normal data.
2. If it includes any table(s), or any part of the table columns in that range.

How could this be achieved using VBA?

Regards,
Don

 

[vletm]

inddon
Do You really mean to delete that data ?
or
would be clear contents ( ~ visible data ) from that range okay?
What is any normal data?
If delete, then there won't be any table anymore ...

 

[inddon]

Hi vletm,

Thank you for your response.

I suppose to clear contents of that range, and if there exists any table(s) then delete the table(s) as well (Without deleting the actual physical rows or columns)

Regards,
Don

 

[vletm]

inddon
This sample should do Your expected checking and deleting with given range.

 

[inddon]

inddon
This sample should do Your expected checking and deleting with given range.

Thank you @vletm. I will adapt your solution.

Regards,
Don