I have written a macro that takes me from the worksheet where I am entering
information regarding an event to a worksheet that has a drawings of various
table and chair layouts that I wish to copy. I would like to go to this
worksheet copy a selected drawing then return to the previous worksheet to
paste copied drawing. The cell formats and range in both the source and
target worksheets are identical.