On Thu, 12 Aug 2010 19:42:47 -0400, Ron Rosenfeld wrote:

On Thu, 12 Aug 2010 04:52:18 -0700, AllInTheChi
wrote:

On Thu, 12 Aug 2010 07:47:46 -0400, Ron Rosenfeld wrote:

On Thu, 12 Aug 2010 04:07:35 -0700, AllInTheChi
wrote:



Title says it all practically. I have a msgbox pop up at times in my
code to tell me about progress plateaus. What I want to do is
incorporate cell value calls, etc. in the msgbox text. Can I use
"CONCATENATE" or other cell functions within macro code?

Yes. Just use the concatenation operator ( & ) to produce your
string.

Something like:

var1 = "Is the Date "
var2 = #9/1/2010#
var3 = " OK?"

s = var1 & var2 & var3
MsgBox (s)

Cool. Thanks. I keep forgetting about making declarations right there
in the code.

Can I use range names and thereby extract cell values on the fly?

Yes


Thanks to the both of you...