Not to sound dumb or anything, but where do I put this info

----- Gord Dibben wrote: ----

kerr

Sub Auto_Fill(
Dim Lrow As Lon
With ActiveShee
Range("C1").Formula = "=A1&B1
Lrow = Range("A" & Rows.Count).End(xlUp).Ro
Range("C1:C" & Lrow).FillDow
End Wit
End Su

Gord Dibben Excel MV

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