| View previous topic :: View next topic |
| Author |
Message |
hihat Newbie

Joined: 11 Dec 2006 Posts: 2
|
Posted: Mon Dec 11, 2006 10:11 am Post subject: reference to sheet with blank in the name |
|
|
Dear OO-users
I looked for this in the help for vain.
I have a document with several sheets, called after months and year, like July 2005, December 2006 and so on. Now I have to refer to some cells in those sheets in an overview sheet. Actually I thought it was like $July 2005.H37 for cell H37 f.ex. If the sheet was just called July $July.H37 would work great, but since there is a space bar / blank in the name, it doesn't want to work.
There must be a way of encapsulating such variable names. I hope there is an easier way than to rename all sheets (there's so many).
Thanks a lot for help.
David
PS: Is there a way to retrieve (and link with) the internal name of a sheet? |
|
| Back to top |
|
 |
Sliderule Super User


Joined: 29 May 2004 Posts: 2477 Location: 3rd Rock From The Sun
|
Posted: Mon Dec 11, 2006 10:36 am Post subject: |
|
|
David:
You asked:
| David wrote: | | Actually I thought it was like $July 2005.H37 for cell H37 |
Change it slightly, to this: $'July 2005'.H37
Since, your sheet name includes a space . . . then . . . encapsulate the sheet name with single quotes ( ' ) and . . . you will get what you want.
I hope this helps, please be sure to let me / us know.
Sliderule |
|
| Back to top |
|
 |
hihat Newbie

Joined: 11 Dec 2006 Posts: 2
|
Posted: Mon Dec 11, 2006 1:56 pm Post subject: |
|
|
Dear One
Thanks for the suggestion. I really thought I tried that one before I posted, but appearantly I must have done s.th. else wrong that time because...
...now it works
Thanks buddy, have a nice advent season
David |
|
| Back to top |
|
 |
|