Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=HYPERLINK("file:///W:\Courtney\Recon\LnRec-8-09.xls#2003-N!A1","September
2009 Reconciliation") The above is obvisouly a hyperlink; however, the formula is not functioning properly. It does take me to the worksheet "2003-N" but instead of "landing" in cell A1, it lands in cell B32. Additionally, I receive an error message that says the reference is not valid. This also happens with any sheet that is named with a dash or minus sign in the name. I feel certain it has to do with that dash, as the formula works perfectly with worksheets that have no dashes/minus signs in the name. Can anyone assist me? Thanks -- Allan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
No plus or minus signs to left of subtotals | Excel Worksheet Functions | |||
How do I get Plus and Minus signs in my additions and subtraction | New Users to Excel | |||
MINUS SIGNS REMOVAL | New Users to Excel | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) |