Hi everyone,

I am currently working on a macro program where I want to copy and paste (the entire row regardless if the value in the 'Source' sheet is a merged cell or not) the value of combo box from one sheet (Source sheet) to another (Destination sheet) upon clicking the 'Search' button, but I'm not sure if what will be the correct code to do it. I hope you could help me on this.

Thank you.