Hi,
Hi have this list of emails on column A:
col A
line 1) email
line 2) email
line 3) email
line 4) email
etc.
i want to concatenate them all into one cell, so i can then copy it to my email client.
Something like this:
a1&","&a2&","&a3& etc.
However the last column is dynamic as it increases with more lines periodically. So i'd like to have a macro that does the concatenate by itself taking in account that the last line can be differente each time.
Is there a way to make this with VBA?
regards,
cogumelo
Hi have this list of emails on column A:
col A
line 1) email
line 2) email
line 3) email
line 4) email
etc.
i want to concatenate them all into one cell, so i can then copy it to my email client.
Something like this:
a1&","&a2&","&a3& etc.
However the last column is dynamic as it increases with more lines periodically. So i'd like to have a macro that does the concatenate by itself taking in account that the last line can be differente each time.
Is there a way to make this with VBA?
regards,
cogumelo