Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extra E-Mail in a Column Q
I have the code below (ex Ron de Bruin) which attempts to extract all
e-mail addresses in column BJ, my problem is that the values in BJ are formula based and thus it debugs, if I manually type an address in BJ it works fine, how could I tweak below? Thanks For Each cell In ThisWorkbook.Sheets("XYZ") _ .Columns("BJ").Cells.SpecialCells(xlCellTypeConsta nts) If cell.Value Like "?*@?*.?*" Then strto = strto & cell.Value & ";" End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminating extra spaces in mail merge with Excel/Publisher | Excel Discussion (Misc queries) | |||
separate data with extra column | Excel Programming | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
How would I add an extra column in a spreed sheet | Excel Worksheet Functions | |||
getting Excel to create an extra column | Excel Programming |