Print

Print


Also, you said that the value 'choDept' is what the user selected from a 
combo box. Using it a Range equation assumes that this name has been 
previously assigned to a named range otherwise it's just a simple string 
and there's nothing behind it. That's what Robert's getting at by asking 
you to use the immediate window and check the value of 'choDept'

Deborah

At 10:26 AM 9/25/00, you wrote:
>Date: Mon, 25 Sep 2000 12:29:28 -0400
>From: "Umlas, Robert " <[log in to unmask]>
>To: "[log in to unmask]" <[log in to unmask]>
>Subject: RE: Range problem
>Message-Id: <BBF884B2DAE9D111A4B200805FA7E5140D9C1867@USNSSEXC03>
>
>What do you get when the macro breaks when you type
>?choDept.Value in the immediate pane?
>Does that value make sense?
>If so, type
>?Range(choDept.Value).Address
>Does that make sense?



%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%