adding text for a specific range

  • Thread starter Thread starter pauluk
  • Start date Start date
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
 
Put this in after you past

Set myrange = Application.Selectio
For Each c In myrang
c.Value = CStr(c.Value) & " ea
Nex
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox for column letter problem 2
Similar Book to Book Code, one works other does not 11
Copy FROM - TO Object/Block variable not set 6
Copy contents of a cell and paste it into text field 1
Varing range 3
How to type each letter of the alphabet automatically in a specific color in Word? 0
Copying specific cell ranges from a worksheet multiple times to a newsheet 3
Copy ranges from several sheets to another one in a vertical position 1

Back
Top