• 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.

VBA Macro

Hi Vishal ,

The problem is that the code has not been written for tables ; where your data is in the form of Excel tables , the code for inserting rows has to be rewritten.

I suggest you do the following :

1. Convert your existing tables to ranges ; this will remove the query connections. Ensure you do not save your files after this conversion.

2. Run the macro , and see whether it works.

If you confirm that it works , then I will rewrite the code to work with tables , after which you can verify whether it works with your query connection in place.

Narayan
 
Hello Narayan,

No No there are not any blank rows
My file is so big and much amount of data so It was not attached by size exceed

So I need to send it in small file for you as a reference, otherwise there are not any blank rows
 
You must log in or register to reply here.
Back
Top