View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Insert the same word at the start of a column of cells

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ann" wrote in message
...
Where do I type in Sub addtext()
--
Thanks,
Ann


"Don Guillett" wrote:

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