Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mwinning8; 07-06-2017 at 12:43 PM.
Please Login or Register to view this content.
Last edited by mwinning8; 07-06-2017 at 12:43 PM.
Please Login or Register to view this content.
Last edited by mwinning8; 07-06-2017 at 12:43 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
I'd just evaluate the formula and just have the value in the sheet:
Please Login or Register to view this content.
Hello,
Thank you very much for the advice, I forgot that was in VBA. My question is how would I set up the Evaluate for ranges of data? Whenever I add it to the from of a code that is supposed to span multiple cells, it only returns the first cells value. That being said, it seems to be running a bit faster already!
Maybe:
* If that doesn't work remove the leading "=" in the formulaPlease Login or Register to view this content.
Sorry to keep pestering you about this, but I cannot seem to get it to work. I've tried:
And that did not work, only returning 0s. When I removed the = sign, that too only returned 0s. I continue to keep getting the first value across.Please Login or Register to view this content.
Last edited by mwinning8; 07-07-2017 at 10:07 AM.
What I see is:
What I advocate is:Please Login or Register to view this content.
Try that.Please Login or Register to view this content.
Oh God, I'm so sorry about that. I believe this time I changed the formula correctly. I made the change to .Value first and it returns me the correct values. However, once I added the Evaluate() string, it once again only returns the first value across all rows.
Please Login or Register to view this content.
I need to play with it - can you:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
attached is the most bare bones thing I could give you. My actual file is 10 MB and the screen I have been discussing is about 5 MB, so the website limitations limited what I could send. I copied the values of the screen before and after a user input to show how it works. I should emphasize that currently the code does everything I need it to do, it just takes about 1-2 minutes to run. I am trying to get it to run completely at around 10 seconds and that was the advice I was looking for. Thank you once again for all the advice and if you need anymore files, I will do what I can!
I think I'm at a loss here - there is no meat in your sample
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks