JJJ,

I have written an add-in that adds a "Transpose Paste-Link" option to the
right-click menu. Contact me privately, and I will send it to you. Change
the dot to ., and take out the spaces.

HTH,
Bernie
MS Excel MVP


"JJJ" wrote in message
...
When I transpose the paste link button greys out. Can I transpose and
paste
the link somehow