Value in a merged cell with a range name

I have a spreadsheet with a spinner button which increases/decreases the value of a certain cell. The cell is actually a two cells merged into one, and has a name associated with it (a named range). When I press another control button on the sheet, I want the control button's VBA routine to read this named range's value and respond to it accordingly, but I'm not sure how to read the value from the spreadsheet.

If the cell's name (range name) is 'bmNumber', how can I read the value and store it in a VBA variable for later use?

Please Login or Register  to view this content.

The above code doesn't want to work for me. I'm guessing it has something to do with the fact that the value is actually from two cells that are merged. Do I need to somehow separate/unmerge the cell before reading a value?

What am I doing incorrectly?

Thanks for the reply and welcome.

The name is associated with the cell formed by the two merged cells.
Would the only way to do this correctly be to name one of the two cells 'bmNumber', merge this cell with the other (unnammed) cell, assign the newly formed (merged) cell a value, and then use 'bmNumber.Value' to retrieve the value?