In Microsoft Excel there are these things called screentips.

I know how to copy and paste a screentip as text to a desired
location.

right-click edit screentip copy paste in new, corresponding range
What I don't know is how to automate this process, as with macros,
because i have a large range in which almost every cell has it's own
screen tip.


That is, i want to isolate just the screen tips from a range of cells,
so that
I will be left with a range of cells that is the pure text version of
what
the original range of cells contained as screen tips.

how do i do this, or is it even possible? I'm open to alternative
methods.