Thanks for the reply!
Trying to get it by:
activeworkbook.names("chk").value
I've not tested the results, but in the immediate window this shows promise:
? evaluate(activeworkbook.names("chk").value)
where the "chk" name is my UDF("input range) call.
I've got another issue I'm working on too, but was not quite ready to give
up yet ... The table I grabbed from the spreadsheet and moved into a
Public (global) variable is of type variant and may have some string
representations of numbers that I will need to change to integers. It
seems once I stick the text in the array it "doesn't want" me to
cInt("string number") coerce it. I can't do the conversions on the front
end because the table is subject to end-user changes with no data
validation...
THANKS AGAIN FOR JUMPING IN :-)
On Friday, September 5, 2014 10:26:57 AM UTC-5, Paul Schreiner wrote:
> You're asking a question about VBA, so you've come to the right place!
> You said"When I try to "get" the return in VBA, it ends up being the
> formula, not the executed function's value."
>
> that shouldn't happen.
> How are you trying to "get" it?
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
