F
Flipper
=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
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