kerri

Sub Auto_Fill()
Dim Lrow As Long
With ActiveSheet
Range("C1").Formula = "=A1&B1"
Lrow = Range("A" & Rows.Count).End(xlUp).Row
Range("C1:C" & Lrow).FillDown
End With
End Sub

Gord Dibben Excel MVP

On Fri, 9 Jan 2004 07:53:41 -0800, "kerri" wrote:

Can anyone help me with an excel question? I want to combine 2 fields (ex: row 1, column a and b) but would also like to combine more than 1 row at a time. Any ideas?