Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing help in Excel 2003
With the following statement:
Debug.Print Application.WorksheetFunction.VLookup("a", "range1", 1) If I hightlight Vlookup and hit F1, I see an error "The page cannot be displayed" Properties upon the error message shows that it tried to access the following address: res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#mk:@MSITStoC:\Program%20Files\Micr osoft%20Office\OFFICE11\1033\VBAXL10.CHM::/html/xlmthVLookup.htm On the above statement, I can however highlight "WorksheetFunction" and press F1 and see the correct help page. Any ideas what's wrong ? At time of installation I did a Full install so everything should exist. Regards, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing help in Excel 2003
if you had
DIM range1 as Range DIM Result as string then result = Application.WorksheetFunction.VLookup("a", Range1, 1,False) If range1 is the textual name of a named range, then result = Application.WorksheetFunction.VLookup("a", Range("range1", 1,False) The '1' in the VLOOKUP returns the value in the first column of the lookup table, the key itself. If so, then MATCH might be a better function. "Steve" wrote: With the following statement: Debug.Print Application.WorksheetFunction.VLookup("a", "range1", 1) If I hightlight Vlookup and hit F1, I see an error "The page cannot be displayed" Properties upon the error message shows that it tried to access the following address: res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#mk:@MSITStoC:\Program%20Files\Micr osoft%20Office\OFFICE11\1033\VBAXL10.CHM::/html/xlmthVLookup.htm On the above statement, I can however highlight "WorksheetFunction" and press F1 and see the correct help page. Any ideas what's wrong ? At time of installation I did a Full install so everything should exist. Regards, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing help in Excel 2003
Thanks, though the question was about the missing help file reference.... a
bug in Excel 2003's distribution. "Patrick Molloy" wrote in message ... if you had DIM range1 as Range DIM Result as string then result = Application.WorksheetFunction.VLookup("a", Range1, 1,False) If range1 is the textual name of a named range, then result = Application.WorksheetFunction.VLookup("a", Range("range1", 1,False) The '1' in the VLOOKUP returns the value in the first column of the lookup table, the key itself. If so, then MATCH might be a better function. "Steve" wrote: With the following statement: Debug.Print Application.WorksheetFunction.VLookup("a", "range1", 1) If I hightlight Vlookup and hit F1, I see an error "The page cannot be displayed" Properties upon the error message shows that it tried to access the following address: res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#mk:@MSITStoC:\Program%20Files\Micr osoft%20Office\OFFICE11\1033\VBAXL10.CHM::/html/xlmthVLookup.htm On the above statement, I can however highlight "WorksheetFunction" and press F1 and see the correct help page. Any ideas what's wrong ? At time of installation I did a Full install so everything should exist. Regards, Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing help in Excel 2003
Hi Steve
it's a problem that has been raised in these ngs before .. to get help on worksheet functions, i find i have to type worksheet functions into the "ask a question box" and then go through the the help task pane to get there . .... :( -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Steve" wrote in message ... Thanks, though the question was about the missing help file reference.... a bug in Excel 2003's distribution. "Patrick Molloy" wrote in message ... if you had DIM range1 as Range DIM Result as string then result = Application.WorksheetFunction.VLookup("a", Range1, 1,False) If range1 is the textual name of a named range, then result = Application.WorksheetFunction.VLookup("a", Range("range1", 1,False) The '1' in the VLOOKUP returns the value in the first column of the lookup table, the key itself. If so, then MATCH might be a better function. "Steve" wrote: With the following statement: Debug.Print Application.WorksheetFunction.VLookup("a", "range1", 1) If I hightlight Vlookup and hit F1, I see an error "The page cannot be displayed" Properties upon the error message shows that it tried to access the following address: res://C:\WINDOWS\system32\shdoclc.dll/dnserror.htm#mk:@MSITStoC:\Program%20Files\Micr osoft%20Office\OFFICE11\1033\VBAXL10.CHM::/html/xlmthVLookup.htm On the above statement, I can however highlight "WorksheetFunction" and press F1 and see the correct help page. Any ideas what's wrong ? At time of installation I did a Full install so everything should exist. Regards, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 xml function missing | Excel Discussion (Misc queries) | |||
missing tabs in Excel 2003 | Excel Discussion (Misc queries) | |||
Missing Reference in Excel 2003 | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 VBA Help - Missing Contents | Excel Programming |