Gary

Where do you want to paste it to?

The code to copy the highlighted cells would simply be

Selection.Copy

Excel then needs to know a destination for the data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"GWB Direct" wrote in message
...
Would like to create a macro that would allow me to highlight certain rown
of
data and paste it to another worksheet. The rows would be different each
time
I run the macro so I need to be able to highlight the rows. Or is there an
IF
statement that I could add to certain data in a sheet that the macro would
read and paste. Hope this question is not too confusing.
--
Gary Baker