Sheet names in EXCEL 1

[DeGeus]

Used program Excel 2000
I want to make a hyperlink to cells in Excel. This hyperlink is made in a VBA program and placed in a cel in another workbook.
Now I found that certain sheetnames are surrounded with single quotes and others not. You can see this when you make a hyperlink manually. Names which generate quotes are for example "D1" or "D2". But not "D1DB" or "D2DB". "DT" and "DTDB" don't generate quotes. Also sheetnames starting with an "R" always generate quotes e.g. "R1" and "R1DB".
Can anybody explain to me why the quotes are generated, and if there are other combinations which generate quotes. I don't need a program to work around in VBA.
Thank you for helping me out



Leendert de Geus

http://WWW.CEC-CES.nl

 

[SkipVought]

Hi,

Excel places quotes around sheet names under these circumstances...
[tt]
Sheet Names
containing spaces,
looking like an A1 style range reference,
looking like a R1C1 style range reference
[/tt]


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DeGeus]

Thanks, now I know how to make my VBA program to work. I simply always place quotes around the sheet name and this always works. Many thanks.

Leendert de Geus

http://WWW.CEC-CES.nl