how to copy& paste special value and stop when find cell with zero value

Hi,

I want to copy a range and paste special value ...ok ?
I dont know the syntax
beside I want copy to loop till it find zero and stop copying


Find my attached file

you will find my vba code in the button fill in.


briefly
copy range A11 : to the end of rows where value = zero from tab inv-oracle and paste them special in column H2 : K2 first try Sales Order destination trial post quest.xlsm


Regards

Maybe:

Please Login or Register  to view this content.

Thanks for your reply
but it pastes #REF!
it need to paste special value
How to do this ?

Thanks again

I tested it on the sample you provided and it seemed to work for me?

Yes it works Thanks

You're welcome. Glad to help out and thanks for the feedback.

Thanks a lot from my deep heart