If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste rows in macro
I need to copy and paste rows using macro. Column P has a number in it. That
is the number that I want to copy rows. |
#2
|
|||
|
|||
Paste rows in macro
Sub copy()
Dim pnum As Integer pnum = Range("P1").Value ActiveCell.Resize(pnum, 12).copy Destination:=Sheets(2).Range("A1") End Sub Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 13:22:26 -0700, murphy wrote: I need to copy and paste rows using macro. Column P has a number in it. That is the number that I want to copy rows. |
Thread Tools | |
Display Modes | |
|
|