| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro to concatenate
I have a spreadsheet with over 1000 lines of entries
12 34 east side west side anyname 23 44 North south again 45 77 Totonto Canada Klein this is street 45 90 where enough sure 66 20 noway sure GONE Most lines contain 5 entries I want to concatenate into col A ONLY the lines that have 3 entries I have written the macro (called MACRO 3) to do the concatenating. I would like a program that would check the entire sheet .Other wise I have to run my macro(Macro 3) on each line manually. Can it be done? Hel[ Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate using Macro | Excel Discussion (Misc queries) | |||
| Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
| Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
| disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
| Concatenate Macro | Excel Discussion (Misc queries) | |||
![pcor[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
