Prev: How do I enter mins and secs in Excel without using caps/colon
Next: Cursor location jumps automatically
From: tran1728 on 6 May 2010 22:23
Dear ALL, pls help me for macro.
I want copy the last row of column A, B and C.
and Paste the row down.

Example, my last row of A is A120, copy cell A120:C120.
then Past to A121

Thanks so much
From: FSt1 on 7 May 2010 00:13
hi
if i understand correctly, this should work for you....
Sub movedownone()
Dim r As Range
Set r = Range("A65000").End(xlUp)
r.Resize(1, 3).Copy Destination:= _
r.Offset(1, 0)
End Sub

regards
FSt1

"tran1728" wrote:

> Dear ALL, pls help me for macro.
> I want copy the last row of column A, B and C.
> and Paste the row down.
>
> Example, my last row of A is A120, copy cell A120:C120.
> then Past to A121
>
> Thanks so much
From: tran1728 on 7 May 2010 03:32
Yes , exactely that i want, thanks so much.

"FSt1" wrote:

> hi
> if i understand correctly, this should work for you....
> Sub movedownone()
> Dim r As Range
> Set r = Range("A65000").End(xlUp)
> r.Resize(1, 3).Copy Destination:= _
> r.Offset(1, 0)
> End Sub
>
> regards
> FSt1
>
> "tran1728" wrote:
>
> > Dear ALL, pls help me for macro.
> > I want copy the last row of column A, B and C.
> > and Paste the row down.
> >
> > Example, my last row of A is A120, copy cell A120:C120.
> > then Past to A121
> >
> > Thanks so much
From: bala_vb on 7 May 2010 14:50

tran1728;952064 Wrote:
> Yes , exactely that i want, thanks so much.
>
> "FSt1" wrote:
> -
> > hi
> > if i understand correctly, this should work for you....
> > Sub movedownone()
> > Dim r As Range
> > Set r = Range("A65000").End(xlUp)
> > r.Resize(1, 3).Copy Destination:= _
> > r.Offset(1, 0)
> > End Sub
> >
> > regards
> > FSt1
> >
> > "tran1728" wrote:
> > -
> > > Dear ALL, pls help me for macro.
> > > I want copy the last row of column A, B and C.
> > > and Paste the row down.
> > >
> > > Example, my last row of A is A120, copy cell A120:C120.
> > > then Past to A121
> > >
> > > Thanks so much --

excel is very flexible tool, you can record a macro manually and excute
it (play with it)

all the best




--
bala_vb
 | 
Pages: 1
Prev: How do I enter mins and secs in Excel without using caps/colon
Next: Cursor location jumps automatically