Copy and paste an active cell in an active worksheet to a merged cells in another workshee

Hi guys,

Is there a VBA code that copies a cell from a worksheet to a merged cell in another worksheet?

I have attached a sample excel below which explains what I am trying to achieve clearly.

Any help will be highly appreciated.

Thanks

Try (put in the Sheet2 module):

Please Login or Register  to view this content.

See attached fyi.

Hi berlan,

It works perfectly fine but is there anyway i can use the code in a module then apply it to a button on sheet2?

I don't want the code to be activated unless i click the button on the worksheet.

Many thanks in advance.

Jin

Hi berlan,

I am trying ti avoid using command button for some reasons so your first suggestion would suit me better. However, when i link the code to the button that i have on my worksheet, it brings the following error message 'user-defined type not defined'.

Any suggestions?

Many thanks