M
m
I have a sheet that was populated with data from a table copied from a
website. One of the rows has cells which contain shapes rather than
text. I need to convert these shapes to text and delete the shapes.
Two questions:
How can I take the current selection and determine just what shape is
in it?
How can I delete that shape after I set the value property to the
desired text?
Something like TypeName(Selection) will tell me that I have a shape if
what is selected is the shape itself. I actually want to select the
cell (or a range of cells) and, based on this, figure out what the
shape might be.
Thanks!
-Martin
website. One of the rows has cells which contain shapes rather than
text. I need to convert these shapes to text and delete the shapes.
Two questions:
How can I take the current selection and determine just what shape is
in it?
How can I delete that shape after I set the value property to the
desired text?
Something like TypeName(Selection) will tell me that I have a shape if
what is selected is the shape itself. I actually want to select the
cell (or a range of cells) and, based on this, figure out what the
shape might be.
Thanks!
-Martin