| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink function fails when using variable row number
It mitght be noted that if you just have one word for the sheet name and
surround it by single quotes like you would if you had two or more words that the single quotes will disappear automatically. Which may account for some of the confusion. experienced. The more complicated formula does *exactly* the same, it is just coded to remove place the sheetname and cell outside of the double quotes. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort : how can I use a variable in a VB sort function? | Excel Worksheet Functions | |||
| Hyperlink function without openening new Explorer every time | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Threaded Mode
