vba on error event #value

Originally Posted by JosephP

if you mean that you are dragging cells to create that REF error then it's no different from regular excel functions. if you use
=REMOVE_RIGHT_SIDE(INDIRECT("A1"))
the function works because the reference is not direct

but can I use this if I need to reference from a different sheet?