View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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