Defining Constants from info in workbook

B

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
 
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top