Dear all
Really needs help with my problems,
with sheet1 range " HI" copy to sheet2 column " A" at last row to down & ended count by column " B,
can some one help the code, pleased
your help I hightly appreciate,
Dear all
Really needs help with my problems,
with sheet1 range " HI" copy to sheet2 column " A" at last row to down & ended count by column " B,
can some one help the code, pleased
your help I hightly appreciate,
Last edited by KK1966; 02-09-2009 at 02:23 AM.
[VBA]Sheet1.Range("H1").Copy sheet2.Cells(sheet2.UsedRange.Rows.Count+sheet2.UsedRange.Row,2).End(xlup)[/VBA]
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Hi, Oorang
Thanks the reply, actually I wanted the code can paste at column "A to down and ended base on column "B last values,
sorry about to made you troubles and confuse.
can you help me again
[VBA]Sheet2.Range("A" & Sheet2.Range("B" & Rows.Count).End(xlUp).Row + 1).Value = _
Sheet1.Range("H1").Value[/VBA]
Something like this maybe?
Daer Georiboy
Thanks you help, can the code paste the value from COL "A last cell to dwom,
Sample:
COL A" last row at A18, and COL B" last Row at B50, can the code paste all values from A18 down to A50 ?
thanks your help
thanks