thole;328278 Wrote:
I need to import a shape from a sheet in my current workbook based on
the value of a non-empty cell in column B.
I have several sheets in which I need to import shapes in Column A (the
shapes all have the same name). These shapes are in other sheets named
after the value in column B. I need to search column B of the
destination sheet for a shape name (ex: SH01), and then search the
workbook for a sheet named "SH01", copy the shape in A1 fro "SH01" into
the destination sheet.Why do you need to import the shape rather than create a similar one
depending on the data?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91727