Defining Constants from info in workbook

[Barb Reinhardt]

If I want to save the value of a "constant", I'd do something like this:


CELLS (i,"A").Value = "=MATCH(""WTD HRS"",""'[""&RC6&""]""&sname""'""'!R7)"

How do I write the results of this as a constant that is not saved in the
workbook.

Thanks,
Barb Reinhardt

 

[Rick Hansen]

Good Morning Barb

I believe this is what your looking for.

Declare constant first by:
Public Const stMatch as String = "=MATCH(""WTD
HRS"",""'[""&RC6&""]""&sname""'""'!R7)"
or
Const stMatch as String = "=MATCH(""WTD
HRS"",""'[""&RC6&""]""&sname""'""'!R7)"

then you can save constant into string variable or you can save it into
a cell as you have in your example. Either way works just fine. Also check
out usinf Static variables in VBA help. I hope this helped out.

HTH
Rick, (Fbks, AK {Land of the Midnight Sun})