Hi mikerickson, thank you so much for your quick answer, I really appreciate it

I’m getting an error (“Application-defined or object-defined error”) on
[VBA]
Set sourceRange = Workbooks("otherBook.xlsm").Names("usInput").RefersToRange [/VBA]