adding text for a specific range
 

I have a work book i copy the info from another now to identifie tha
that range i have just copied i place a letter in colum c ea

The copying macro is fine, all i wish to know what do i add t
automactally place the letters ea into colume c for the range i hav
just copied

--
Message posted from http://www.ExcelForum.com

adding text for a specific range
 

Put this in after you past

Set myrange = Application.Selectio
For Each c In myrang
c.Value = CStr(c.Value) & " ea
Nex