Thread
:
Insert the same word at the start of a column of cells
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett