Forum Discussion
Riley_Johnson
Apr 23, 2024Copper Contributor
Using VBA to test whether values input into a cell throw an error in another cell
I have this function called funcContentsErrorFree that takes three arguments and returns a Boolean value. Arguments: Range address As String to a series of values (or single value) Range addre...
Riley_Johnson
Apr 24, 2024Copper Contributor
Update:
The source of the error is the Range(refInput).Value assignment lines. See Screenshot.
When these lines are commented out, the code runs error-free but does not perform its designed task.