using VBA to copy paste table when cell value - VBA error

Hi

my last thread was on how to use VBA to copy paste table from another sheet if a cell value - and thanks to (Willy) everyting is good
http://www.excelforum.com/excel-prog...ell-value.html

But i have a problem after completing the project wich is:

- notice the behavior of the "Parts order" sheet when i change the service type
. A & B = good
. C & D = the table is not fixed in its place the correct way

I have tried so many times to figur the problem but i couldnt find any soluation

Attached the project file
SERVICE LIST 1.xls

will some one help me pls

thx in advance

brdstyle;

Please be a little patient. It has only been six hours since your original post. In many parts of the world it is still Sunday and many people are not on the forum.

I refer you to our rules --> http://www.excelforum.com/forum-rule...rum-rules.html

and in particular to section "Want to get your Question answered Quickly" and the bullet

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.