| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the occurrence of specific text within a date range | Excel Worksheet Functions | |||
| Count percentage of specific text in a range of cells | Excel Worksheet Functions | |||
| Adding random #s in a range to equal a specific # | Excel Worksheet Functions | |||
| adding numbers in a specific range of values | Excel Discussion (Misc queries) | |||
| Summing values in a range against specific text | Excel Discussion (Misc queries) | |||
![pauluk[_49_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
