View Single Post
 
Old 11-24-2019, 05:56 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,421
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Try declaring DecisionsDoc and ComplaintDoc as global variables (ie at the top of the module before any Subs). It will save you having to pass them between functions and possibly make them more robust as your code progresses.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote