hi there,
i noticed your post in egghead cafe for the excel macro function to reveal the email embedded within the name.
i followed the link verbatim, but am having no success. apparently some the was some error in the code. At least that's the message i got.
was i supposed to modify the VBA code before installing?
CyberTaz wrote:
Wellll there ya go !
30-Dec-09
Wellll there ya go !;-
Regards |:>
Bob Jone
[MVP] Office:Ma
On 12/30/09 7:09 PM, in article C76236CD.6809%
[email protected], "John
Previous Posts In This Thread:
Excel Function Help
Hi Al
I have names in column A When placing mouse over the name it reveals
mailto:
[email protected] I need the formula to reveal these emai
address in another column
I have trie
=Hyperlink (A1
=Address (A1
=GetAddress (A1
Please hel
Mike Ippolito
See here:
http://www.ozgrid.com/VBA/HyperlinkAddress.
See here:
http://www.ozgrid.com/VBA/HyperlinkAddress.ht
On 28/12/09 8:37 AM, in article C75D3DD7.13B7%
[email protected]
-
The email below is my business email -- Please do not email me about foru
matters unless I ask you to; or unless you intend to pay
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer
McGhie Information Engineering Pty Lt
Sydney, Australia. | Ph: +61 (0)4 1209 141
+61 4 1209 1410, mailto:
[email protected]
Wellll there ya go !
Wellll there ya go !;-
Regards |:>
Bob Jone
[MVP] Office:Ma
On 12/30/09 7:09 PM, in article C76236CD.6809%
[email protected], "John
Hi John,Does the Mac version of vba support 'Replace'?
Hi John
Does the Mac version of vba support 'Replace'? If not, the function could be coded as
Function GetAddress(HyperlinkCell As Range
GetAddress = Application.Substitute(HyperlinkCell.Hyperlinks(1).Address, "mailto:", ""
End Functio
-
Cheer
macropo
[Microsoft MVP - Word]
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Mutipart MIME Encoding Library using CDO
http://www.eggheadcafe.com/tutorial...c0-6623da269eb5/c-mutipart-mime-encoding.aspx