you need to test the value of the cell as excel may have automatically converted an email address to a hyperlink
vb Code:
msgbox cells(x, y) msgbox cells(x, y).text msgbox cells(x, y).hyperlinks(1).texttodisplay
|
Results 1 to 7 of 7
Thread: [RESOLVED] For loop problemThreaded View
|
Click Here to Expand Forum to Full Width |