copying rows using macro

[ashishprem]

Hi All,
I want to copy rows from 1 worksheet to other worksheet in the same file using macro. But i am not getting. Please help me guys. Its really urgent.
Thanks
Regard,
Ashish

[Bob Phillips]

Worksheets("Sheet1").Rows("1:10").copy _
Worksheets("Sheet2").Rows(8)

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashishprem" <[email protected]> wrote
in message news:[email protected]...
>
> Hi All,
> I wnat to copy rows from 1 worksheet to other worksheet in the same
> file. But i am not getting. Please help me guys. Its really urgent.
> Thanks
> Regard,
> Ashish
>
>
> --
> ashishprem
> ------------------------------------------------------------------------
> ashishprem's Profile:
http://www.excelforum.com/member.php...o&userid=31485
> View this thread: http://www.excelforum.com/showthread...hreadid=511632
>

[ashishprem]

Thanks buddy..