Set Range syntax - currently causing #value! error sometimes

Please Login or Register  to view this content.

i have a situation where I am troubleshooting a user function that returns #value! errors when this block of code is in, however when i comment it out, it will return a basic value like

Please Login or Register  to view this content.

obviously there is other stuff in there. am i referring to this range incorrectly? this block of code works perfectly when the user inputs of my function create a specific type of result but not others. when i tried to step into this function via a sub, i would get overflow errors on the first calculation (that was simple division).

any ideas?

it had something to do with the variable declarations - i just reworked the code to no longer need those references and everything is proper now. thank you for your help