excel function on eggheadcafe
yajrathakrishnan
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 Jones
[MVP] Office:Mac
On 12/30/09 7:09 PM, in article C76236CD.6809%jo...@mcghie.name, "John
Previous Posts In This Thread:
On Sunday, December 27, 2009 4:37 PM
Mike Ippolito wrote:
Excel Function Help
Hi All
I have names in column A When placing mouse over the name it reveals a
mailto:emaila...@email.com I need the formula to reveal these email
address in another column.
I have tried
=Hyperlink (A1)
=Address (A1)
=GetAddress (A1)
Please help
Mike Ippolito
On Wednesday, December 30, 2009 7:09 PM
John McGhie wrote:
See here: http://www.ozgrid.com/VBA/HyperlinkAddress.
See here: http://www.ozgrid.com/VBA/HyperlinkAddress.htm
On 28/12/09 8:37 AM, in article C75D3DD7.13B7%mi...@themlmheadhunter.com,
--
The email below is my business email -- Please do not email me about forum
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 Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:jo...@mcghie.name
On Wednesday, December 30, 2009 7:23 PM
CyberTaz wrote:
Wellll there ya go !
Wellll there ya go !;-)
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 12/30/09 7:09 PM, in article C76236CD.6809%jo...@mcghie.name, "John
On Thursday, December 31, 2009 2:14 AM
macropod wrote:
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 Function
--
Cheers
macropod
[Microsoft MVP - Word]
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# Mutipart MIME Encoding Library using CDO
http://www.eggheadcafe.com/tutorials/aspnet/74032d0b-6662-4b82-acc0-6623da269eb5/c-mutipart-mime-encoding.aspx