Running a macro to concatenate

  • Thread starter Thread starter pcor
  • Start date Start date
P

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
 
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 said:
you need to use a loop.

dim cell as range

for each cell in range("your range")

'your macro here

next cell






pcor said:
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
 
Back
Top