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.

As always, post your code for comments. It is HIGHLY likely that you need
NOT goto the destination sheet at all.
with sheets("destinationsheet")
range("a2:a22").copy .range("a2")
end with
--
Don Guillett
SalesAid Software

"BarryL" wrote in message
...
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.

Don,

Thanks for the response. I did not include code earlier since there really
isn't any yet. But I'm still hopeful <smile.

The program I have developed is an event booking system that uses a calendar
hyperlinked to 90 plus worksheets (3 per day). Each worksheet is an event
booking form that has space for event details including a room layout. I
want to provide the form users with a drawing of a room layout that is
appropriate to their needs and I have created a separate sheet with a series
of layouts drawn to fit into the space on the the event sheet for the drawing
of the room layout.

I considered not actually going to the Rm-Layouts ( ie choosing the layout
from a table of layouts and handling the copying as you suggested) but since
I my users tend to be visual they need to be able to see the various layouts
to know which one might serve their needs best. In this case it is helpful
to actually go there and scroll through a series of previously drawn layouts.

Then, after selecting a layout that will work, I had hoped I might just copy
that particular layout and return to the original worsheet and paste it into
the appropriate range.

Code so far...

Sub
Sheets("Rm-Layouts").Select
End Sub

"Don Guillett" wrote:

As always, post your code for comments. It is HIGHLY likely that you need
NOT goto the destination sheet at all.
with sheets("destinationsheet")
range("a2:a22").copy .range("a2")
end with
--
Don Guillett
SalesAid Software

"BarryL" wrote in message
...
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.