[Solved] Get value of named cell when sheet is unknown

[bartjeman]

I have a named cell "kneeheight" on sheet "Order Entry" (sheet0)

A macro is called from a button on the active sheet "Drawing" (sheet1). When I use getCellRangebyName("kneeheight"), I get an error. However when I copy the button to the sheet "Order Entry" (sheet0) it works.

Is there a way to get the value of a named range that is not on the active sheet?

Thanks

[bartjeman]

I did more googling and got this working:
KneeType = oDoc.NamedRanges.getByName("kneetype").getReferredCells.value

What would be the equivalent code if the cell contains text? I tried ".string" which does not work

Thank you.

[FJCC]

Every cell has a String property, so that should work. This worked for me

Code: Select all

CellString = ThisComponent.NamedRanges.getByName("First").ReferredCells.String
Print CellString

What do you mean when you say it didn't work?

[bartjeman]

Thanks FJCC
oo maros are so quirky... I noticed you used "ReferredCells" as opposed to my "getReferredCells" and both seem to work fine with

Bone head mistake, I did not think that my named range could be misspelled, but guess what, it was

Thanks