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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro to concatenate
Not too sure on how to do that
can you give me a sample of code and where to place the code Thanks "Cesar Zapata" wrote in message ... you need to use a loop. dim cell as range for each cell in range("your range") 'your macro here next cell "pcor" wrote in message le.rogers.com... 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 |
Reply |
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) |