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