JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
I've found a code that was supposed to Text Join visible cells only but it did'nt work or i did something wrong.
Goal: To join visible cells in a column and join them with a semi colon in between each. I am joining email addresses that are visible based on what has been filtered. To create a multiple email string.
1) Would need the code to join email addresses in column B, for example.
2) Would like the code to combine the visible filtered cells in any column that a user places the cursor on. Active cell would be ideal if possible, just in case i have a spreadsheet where the email addresses are in another column......and if possible, to make the code recognize that the active column does not contain email addresses.
2.5) A message box that says "The column you've chosen does not contain email addresses. Try again". With "Okay". Something like that.
3) If employee names are in column A and email addresses are in column B, then i would like the code to produce a result in a cell that is 3 rows above the header of column B.
4) The header row is on row 5, the employee names and addresses list starts on row 6. Would like the results in row 3.
5) Would like a command button if necesarry. Disregard if the TextJoin function will automatically be generated after the filter has been set. I don't know how this part works.
Result in row 3
Header is in row 5
Email list in excel starts in row 6.
Thank you so much.
Juicy,
Goal: To join visible cells in a column and join them with a semi colon in between each. I am joining email addresses that are visible based on what has been filtered. To create a multiple email string.
1) Would need the code to join email addresses in column B, for example.
2) Would like the code to combine the visible filtered cells in any column that a user places the cursor on. Active cell would be ideal if possible, just in case i have a spreadsheet where the email addresses are in another column......and if possible, to make the code recognize that the active column does not contain email addresses.
2.5) A message box that says "The column you've chosen does not contain email addresses. Try again". With "Okay". Something like that.
3) If employee names are in column A and email addresses are in column B, then i would like the code to produce a result in a cell that is 3 rows above the header of column B.
4) The header row is on row 5, the employee names and addresses list starts on row 6. Would like the results in row 3.
5) Would like a command button if necesarry. Disregard if the TextJoin function will automatically be generated after the filter has been set. I don't know how this part works.
Result in row 3
Header is in row 5
Email list in excel starts in row 6.
Thank you so much.
Juicy,