I get this message and it debugs to my code here. The part in red is where it is highlighted by VBA
Please Login or Register to view this content.
Anything obvious triggering this error?
I get this message and it debugs to my code here. The part in red is where it is highlighted by VBA
Please Login or Register to view this content.
Anything obvious triggering this error?
Impossible to tell from code snippet alone.
The code compiles so it must be the values held in the variables.
Use debugger to check content of the values and returned values from functions. Make sure the calculations result in positive values.
Impossible to tell from code snippet alone.
The code compiles so it must be the values held in the variables.
Use debugger to check content of the values and returned values from functions. Make sure the calculations result in positive values.
Hi Andy - many thanks for your reply.
Please advise how i'd go about doing the last sentence?
Quickest way, if you don't know how to use the debugging tools in VBE is to use Debug.Print command.
This will output the values in the Immediate window. You can see the immediate window by typing CTRL+G in VBE
add extra lines for other parts of the command.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks