If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
VLOOKUP RESULTS AS A HYPERLINK
Takhan via OfficeKB.com wrote:
I have done the VB function and then copied the formula you told me and in cell it says #NAME? Then you can't have done it rightg It worked fine for me. With the workbook open, Alt+F11 to the VB editor, in Project Explorer, expand the project for your workbook (make sure it is not a different workbook's project), double-click Module1 and check that the function is indeed present there. If you don't have a Module1 then you didn't put it in the right place. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#12
|
|||
|
|||
VLOOKUP RESULTS AS A HYPERLINK
Hi Bill,
I have put the info in module 1 and the formula in sheet but still it says the same. Regards Ahmad Bill Manville wrote: Takhan via OfficeKB.com wrote: I have done the VB function and then copied the formula you told me and in cell it says #NAME? Then you can't have done it rightg It worked fine for me. With the workbook open, Alt+F11 to the VB editor, in Project Explorer, expand the project for your workbook (make sure it is not a different workbook's project), double-click Module1 and check that the function is indeed present there. If you don't have a Module1 then you didn't put it in the right place. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...links/200806/1 |
#13
|
|||
|
|||
VLOOKUP RESULTS AS A HYPERLINK
Send me the workbook (Bill underscore Manville at compuserve dot com)
and I'll take a look Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
|
Thread Tools | |
Display Modes | |
|
|