Hi, wonder if anyone can help with this little conundrum. I want to run
a macro that copies a specific row of data from a specific worksheet
and pastes it into another worksheet. I want to specify which
particular row the date gets pasted onto though, preferably by simply
highighting the destination row and then running the macro. At the
moment I am using a manual cut and paste process but would love to make
my workbook a bit slicker. Assistance appreciated. Thanx Andy Fletcher

as always, post your macro for comments. You haven't told us where to copy
to??


--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Hi, wonder if anyone can help with this little conundrum. I want to run
a macro that copies a specific row of data from a specific worksheet
and pastes it into another worksheet. I want to specify which
particular row the date gets pasted onto though, preferably by simply
highighting the destination row and then running the macro. At the
moment I am using a manual cut and paste process but would love to make
my workbook a bit slicker. Assistance appreciated. Thanx Andy Fletcher

Don, as requested:

ActiveWindow.SmallScroll Down:=-3
Sheets("Clipboard").Select
Range("A21:H24").Select
Selection.Copy
Sheets("Points List").Select
Range("A9").Select
ActiveSheet.Paste

As you can see I am copying a standard plant configuration from the
worksheet called clipboard. I may want to paste the selection at any
row on the destination worksheet. The column configuration will always
remain the same though.

Cheers,

Andy

Are you ALWAYS copying A21:H24 on the Clipboard sheet?

Can't you do something like this with the destination already selected?
(*warning* untested)

dim x as variant
set x = activecell
Worksheets("Clipboard").range(("A21:H24").Copy(x)


" wrote:

Don, as requested:

ActiveWindow.SmallScroll Down:=-3
Sheets("Clipboard").Select
Range("A21:H24").Select
Selection.Copy
Sheets("Points List").Select
Range("A9").Select
ActiveSheet.Paste

As you can see I am copying a standard plant configuration from the
worksheet called clipboard. I may want to paste the selection at any
row on the destination worksheet. The column configuration will always
remain the same though.

Cheers,

Andy

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

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