ANSWERS: 3
-
Perhaps the script is referencing something on your spreadsheet that he does not have?
-
With no idea what your macro looks like, this is tough to guess at ... But I'm going to guess that the specific element he's not finding is a particular Range Name that you have on your source worksheet and which your friend doesn't have on his.
-
Your worksheet has a named range and your friend's hasn't. Change your macro to reference a range of cells, rather than a named range, or get your friend to name the range the same as yours. Alternatively mail him the entire workbook.
Copyright 2023, Wired Ivy, LLC

by 