Posted to microsoft.public.excel.misc
|
|
Insert the same word at the start of a column of cells
try
Sub addtext()
For Each c In Range("e2"). _
Resize(Cells(Rows.Count, "e").End(xlUp).Row - 1)
c.Value = "Muratec " & c
Next c
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ann" wrote in message
...
I have a column of descriptions and want to insert the word Muratec in
front
of each description. Does anyone know how to do this?
--
Thanks,
Ann
|