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

Answerbag | Terms of Service | Privacy Policy