Len,
Nancy posted the most likely solution to the problem in her original post to Lucien. Since he's not made any other posts in the thread it's impossible to know if hers is the correct solution.
If you and Andrew aren't capable of scanning the whole thread to see the answer it's not Nancy's problem.
Macros work perfectly well inside method code.>There was nothing to explain to Andrew (or myself) as to why he was wrong, & it's lowered my opinion of her considerably.