Hello Sri,
I guess i know what is the problem, but I can't try it, because I am really a beginner at macros (I am more a formula-fan).
I think you always have to create the sheet "Transpose_temp" in the same sheet as the destination.
Check it out and give. It would be interesting to hear if it works or not.
Kind regards
Bjorn
|