I would like to have VBA function for "Golden-section search"
Jan 13, 2020 · The golden-section search is a technique for finding an extremum (minimum or maximum) of a function inside a specified interval. The example below finds a minimum:
Golden Ratio Excel VBA Function | MrExcel Message Board
May 11, 2011 · I made a VBA function for Excel to accurately calculate the Golden Ratio of a number. It's a simple function, and maybe useful to someone. Public Function GoldenRatio(Optional ByRef …
Trouble creating golden search function for profit maximization
Feb 22, 2010 · The goal is to find the optimal speed for an 18 wheeler to travel to maximize profit. The answer should come out to 72.7 mph and $59.76 per hour. I can't seem to fix my function to arrive at …
Hide Rows based on search-text in cell - MrExcel
Apr 10, 2025 · Hide rows based on that search cell or Show rows based on that search cell? When something is typed into cell B1, should we be looking in column B for that text? or column H? or …
vba code highlight in yellow | MrExcel Message Board
Feb 26, 2002 · I know nothing about vba and I need all the help I can get to make this project work. I found this code elsewhere on the net and I am asking for help to get it to work for me if possible. let …
Issue with Excel automatically expanding selection of cells
Mar 23, 2025 · Hello, I recently switched over to 365 and I have been having this issue with Excel I cannot seem to figure out! When I click my mouse once on a single unmerged cell, Excel will …
Error Message: Run-time error '287': Application-defined or ... - MrExcel
Feb 23, 2017 · Hey guys I use a spread sheet with a Macro built by someone who left my team a year or so ago - Up until now I've had no issues with the Macro. The Macro pulls data from a mailbox in …
Power Pivot Data Model Error | MrExcel Message Board
Aug 25, 2010 · Hi All, Ive had a search online but theres a lot of noise with no definitive answers on this. A sheet I have - has a data model in it. Any Pivot that...
How to show the map chart, to display regions - MrExcel
Feb 23, 2022 · HI trying to make a map chart that displays the regions per sales man, but all i get is this It does not show the regions My data is structured like this 1595 Clavaleyres Schweiz Salesman1 …
Bug? Inserting Row (Keyboard Shortcut) doesn't add a row but instead ...
Jun 12, 2018 · Hi all, I've only recently gotten this weird behavior out of Excel so I'm not sure what's going on. I press Ctrl+Shift+Plus and a row does not get inserted but all the formulas in the cells …