You could try this:
Copy|paste special|paste link
(but in an out of the way location)
Then select those cells
edit|replace
what: =
with: $$$$$= (some unique string)
replace all.
Now those formulas are strings
Copy|paste special|transpose
select the range
edit|replace
what: $$$$$= (same string)
with: =
replace all
And clean up that out of the way helper range.
JJJ wrote:
When I transpose the paste link button greys out. Can I transpose and paste
the link somehow
--
Dave Peterson
|