I have a spreadsheet which I inherited from the last person who held my job. I believe he used vb to create his own formula which took all the matching item numbers from a given range, added them and placed the sum in a corresponding linked page. My problem is I need to determine exactly how this formula was derived so I can repeat it and/or improve it on a new sheet. I know this is out there but if someone could help it would be greatly appreciated.
Open the book in which the formula appears. Press Alt + F11. Look for Function or Public Function and then a name which matches the function you see entered into the spreadsheet.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Look in the cell where the results are.
If it looks something like this "=myUDF(A8,A9,A10....)" then what Thomas suggested should work.
It it's just a number, then a macro probably put it there, but there's no telling what macro did it. You would have to search all the macros in the workbook looking for that cell. Hopefully (s)he named the cell(s) and you can do a search for the name. If not, you will just have to look at all the macros looking for which one put a value into that cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks