vba copy

[KK1966]

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,

[Oorang]

Sheet1.Range("H1").Copy sheet2.Cells(sheet2.UsedRange.Rows.Count+sheet2.UsedRange.Row,2).End(xlup)

[KK1966]

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

[georgiboy]

Sheet2.Range("A" & Sheet2.Range("B" & Rows.Count).End(xlUp).Row + 1).Value = _
Sheet1.Range("H1").Value

Something like this maybe?

[KK1966]

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