PDA

View Full Version : vba copy



KK1966
02-09-2009, 01:59 AM
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
02-09-2009, 07:03 AM
Sheet1.Range("H1").Copy sheet2.Cells(sheet2.UsedRange.Rows.Count+sheet2.UsedRange.Row,2).End(xlup)

KK1966
02-09-2009, 07:17 AM
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
02-09-2009, 07:26 AM
Sheet2.Range("A" & Sheet2.Range("B" & Rows.Count).End(xlUp).Row + 1).Value = _
Sheet1.Range("H1").Value

Something like this maybe?

KK1966
02-09-2009, 08:12 AM
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