Dependent drop down dynamic range formula, off sheet.
On Friday, December 19, 2014 1:20:27 AM UTC-8, Claus Busch wrote:
Hi again,
Am Fri, 19 Dec 2014 10:04:47 +0100 schrieb Claus Busch:
the depending list must have a fix range. It will not work with dynamic
range names
if you want dynamic names in CSI_DETAILED you have to do it with VBA.
In a standard module:
Okay, thanks Claus.
I will work with the event code you posted, I already have one going on the sheet.
Will see what I can do.
I have to be away from my computer for awhile, but I will get back for more help or to let you know I got it going.
Thanks again.
Howard
|