Defining Constants from info in workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb Reinhardt - 22 Jun 2006 18:04 GMT

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

Reply to this Message

Rick Hansen - 22 Jun 2006 18:42 GMT

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})

> If I want to save the value of a "constant", I'd do something like this:
>
[quoted text clipped - 5 lines]
> Thanks,
> Barb Reinhardt

Reply to this Message