Hi Everyone,
I'm Trying to use NP("Eval") with a formula i have but its not working.
in Merged Cell I3:O4 i currently have =D3&" , "&"( Day "&E3&" of "&F3&" )"Which Returns, "Saturday, Jul 18 2009 , ( Day 13 of 23 )"
but when i run a macro (Which deletes Hidden Columns and Sheets) i get a #REF! Error.
So i tried =NP("Eval","=D3&" , "&"( Day "&E3&" of "&F3&" )"")
but it just wont work.
I also read that any ampersand characters need to be enclosed in single quotation marks to work.
resulting in =NP("Eval","=D3'&'" , "'&'"( Day "'&'E3'&'" of "'&'F3'&'" )"")
But this also…doesn't work.
i know i can have NP("Eval","=Cellreference")
and have the cellreference with the formula but ive already got too many of those in the columns.
One last thing,
i dont need it for just this example.
I'd also like to use it for "=CONCATENATE("Run by ",D10," at ",TEXT(NOW(),"HH:MM AM/PM dd/mm/yyyy"))"
Where D10=: =UPPER(MID(D6,FIND("\",D6)+1,LEN(D6)-FIND("\",D6))) (This gets the user name out of "My Session", which is DOMAIN\USERNAME
And D6=: =nl(1,"Session","User ID","My Session",TRUE)
Can anyone please help?
-Bromy
Date
Votes
1 comment
-
Jet Reports Historic Posts Uploading your sheet and macro would help… I have made a macro myself doing the same, or more precise it is part of self-made COM-addin which add rich functions to Excel. It works nearly perfect with the exception of spit cells/columns.
One last thing,
i dont need it for just this example.
I'd also like to use it for "=CONCATENATE("Run by ",D10," at ",TEXT(NOW(),"HH:MM AM/PM dd/mm/yyyy"))"
Where D10=: =UPPER(MID(D6,FIND("\",D6)+1,LEN(D6)-FIND("\",D6))) (This gets the user name out of "My Session", which is DOMAIN\USERNAME
And D6=: =nl(1,"Session","User ID","My Session",TRUE)D10 = UPPER(RIGHT(D6,SEARCH("\",D6)+1))
Somewhat faster formula…
Please sign in to leave a comment.