I am trying to use the VBA Log function in an expression and I expect it to work on any number greater than 0. However, when I enter a relatively large number (e.g. 500 or 1,000), I get the error mentioned in the title. Here is the function:
I am using Option Explicit and I get the error when I enter x as any number greater than about 500.
Please Login or Register to view this content.
Works just fine for me.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Maybe it has something to do with the sub I'm using the function in then? It gives the error if x is anything above exactly 403 (after further testing) and when I click "Debug" It highlights the line where I defined f_x.
Full code:
Please Login or Register to view this content.
Simple enough answer. Numbers above 403 will cause next_guess to go below zero making the Log() call invalid.
WBD
Office 365 on Windows 11, looking for ✶ rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks