I have several lines of code that currently input a formula into several different cells. Basically these cells echo data from one sheet to the dashboard. I would like to only have the values appear if possible. Can this array of formulas be written using Evaluate?
Please Login or Register to view this content.
Last edited by Mr_Bill; 09-19-2014 at 01:22 PM. Reason: Typo in title
This converts the formulas to values
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you it did work but not how I planned need to rethink this one. Does this only return the value of the cell in the array once? Any thought how I could get the cells to auto update as if they were still ='Random Name'!P2 or would I need to have line like Range("D2").Value = Range("'Random Name'!P2").Value for every cell I want to do this to? These codes are automatically input in a newly generated section of the dashboard when a new sheet is generated so I am thinking I am stuck with them as is.
A formula is probably the best way for the cells to auto-update.
What's the problem with using a formula if it works? I don't follow what the issue is.
Part an OCD thing, part my mind tells me the page would work faster with less on it, and part pain to copy and paste from that page as the formulas get copied.
One more if you are up it can a sumif be done in the evaluate? I tried but it doesnt do anything and gives no error
Range("E6").Value = Evaluate("=SUMIF($D$6:D8000,"">=0"", $E$6:E8000)")
What it should do is if one of the cells in D is blank or has a - it wont add the adjacent cell in E to the total
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks