How can I put in a variable that comes from a named cell in the spreadsheet.

Here's my line, and I'd like

QuestionToMessageBox = ("Are you CERTAIN you've copied the contents of this sheet into a new one?" _

& namedCellFromSheet & " some more text?")

Hi David,

Am Thu, 9 May 2019 23:45:35 -0700 (PDT) schrieb David Godinger:

How can I put in a variable that comes from a named cell in the spreadsheet.

Here's my line, and I'd like

QuestionToMessageBox = ("Are you CERTAIN you've copied the contents of this sheet into a new one?" _

& namedCellFromSheet & " some more text?")

try:

QuestionToMessagebox = MsgBox("Are you CERTAIN you've copied the contents of this sheet into a new one? " _
& Range("Sheet1!NamedCell.Name") & " some more text?", vbYesNo, "Question")


Regards
Claus B.
--
Windows10
Office 2016

Thanks, Claus, it worked perfectly!

The little piece of my VBA ended up looking like: & Range("Chart!nameInsert") &