• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Delete any data/table exists in a given range.

inddon

Member
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

Excel Ninja
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

Member
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
 
Top