copy and insert row from excel

Can anyone tell me how to copy number of rows from an excel worksheet and insert those rows on another worksheet using VB?

I know this i possible but i dont know how. Can anyone help me?

Thanks,
kristine

you do something like:

Sheets("Sheet1").Select
Range("8:8,11:11,14:14").Select
Selection.Copy
Sheets("Sheet2").Select
Rows("10:10").Select
ActiveSheet.Paste

When I want to do a common excel function in vba, but don't know how to do it, I will create a macro for what I want done, then look at the code generated by the macro. Most of the time I will paste the macro code directly into my own routines. This method has probably taught me more about VBA than anything else.

kevin

Thanks a lot guys!!! you gave me an idea.