Running a macro to concatenate

[pcor]

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

 

[pcor]

Not too sure on how to do that
can you give me a sample of code
and where to place the code
Thanks

you need to use a loop.

dim cell as range

for each cell in range("your range")

'your macro here

next cell

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