adding text for a specific range

P

pauluk

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
 
C

chris

Put this in after you past

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