Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default IFERROR function with Hyperlink

Hi,

I'm trying to use the IFERROR function with hyperlink functions. I
want the worksheet function to work like this: IF the hyperlink to
the specific Device page returns an 'Unable to open' error message,
then I want it to open the Main Page (which will always open). But,
the worksheet function below continues to return the error message and
doesn't open the Main Page. Am I doing something wrong, or can this
function not be used this way? If not, are there any suggestions for
how to make this work? Thanks!


IFERROR(Hyperlink(E32,"Device"),Hyperlink(E31,"Mai n Page"))
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan Excel Worksheet Functions 4 April 15th 09 03:25 PM
iferror Roy Gudgeon[_2_] Excel Worksheet Functions 13 July 31st 08 05:24 PM
Can't make hyperlink function work for hyperlink to website Frank B Denman Excel Worksheet Functions 15 February 6th 07 12:01 AM
How do I create a hyperlink to a cell with the hyperlink function S. Bevins Excel Worksheet Functions 2 July 20th 06 08:06 PM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"