unable to add data into active cell through macro

hey,
ya i know but i have to work with the merged cells unfortunately.
Can you help me place the merged cell spitted from the macro to be placed on a cell which i clicked before running the macro??

Originally Posted by AB33

You can not work with merged range. If you are trying to loop through a merged range, or copy, you are more likely to get an error.
Consider this quote:

"Merged Cells are the work of the Devil"