PS you can also use Evaluate with your original formula string and assign the result to the range directly if you prefer.
PS you can also use Evaluate with your original formula string and assign the result to the range directly if you prefer.
Everyone who confuses correlation and causation ends up dead.
is this the way you would do it instead of using the application.worksheetfunctions?
Yes, it is.
(well, strictly speaking, I would probably redesign the entire workbook if it were that slow)
thats kinda what i am trying to do via not using formulas where i can but instead values........
so how wouldi use the Evaluate.........
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks