Duke,

Thats tremendous, works a treat! It needs a bit of refining now though
because there are many plant configurations on the clipboard it is
difficult to remember each name. The configurations have names like
two_boilers_flow_and_return_temperature_sensors.

I was hoping to be able to either:

1: Assign each configuration to a macro button
or:
2: Access some sort of drop down list or list inserted into right click
menu. (Preferable)

Nonetheless what we have achieved is a great step forward. THanks for
your help so far and if you have any ideas about the above I would be
very pleased to hear em.

Regards,

Andy FLetcher





Duke Carey wrote:
No error checking in the previous code. Use this instead

Sub CopyPlant()
Dim x As Variant, strRange As String

Set x = ActiveCell
strRange = InputBox("Plant Config?", "Range to Copy", "Plant")
If strRange = "" Then Exit Sub

Worksheets("Clipboard").Range(strRange).Copy (x)

End Sub

" wrote:

Hi Duke,

CHeers for that. Im afraid that i not sure how to get this into a
macro, i assume that its via VB editor. Im a bit of a novice in
this
area and wonder if you could advise me as to how to implement the
code
you have suggested.

Again, thanks.

Andy


Duke Carey wrote:
You use a range name as demonstrated below

dim x as variant
set x = activecell
Worksheets("Clipboard").range(range_name).Copy(x)

If you only had a small number of of ranges that you'll copy, you
could
create a separate Subroutine for each one, then add buttons to
your
toolbar
and assign each subroutine to a different button.


wrote in message
oups.com...
Hi, THx for the prompt response. No there are various
cellranges
with
different configurations of plant that I want to copy from the
clipboard to rhe points list. I have taken this further now
and
named
these ranges, so I should be able to reference to the names.
With
respect to the formula how do I get that into a macro? Sorry
dont
know
anything about VB. Thanks again for your interest in assisting
me.
Andrew