| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through range and add each cell contents to a string
Hi there,
Say I have a range A1:A100. How, when clicking a command button, do I get excel to loop through the range adding the contents into a string with a colon between each entry? e.g. A 1 2 3 4 Becomes ;pete@pete .com" Many thanks, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
| Loop through range of cells, string search, take action | Excel Programming | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| IF Cell Contents Start with STRING | Excel Worksheet Functions | |||
| How easy is it to loop in VBA based on cell contents? | Excel Worksheet Functions | |||
Threaded Mode
