Just type in the name:

'Sheet 99'!a1:a11

Jeff wrote:

Hi,

I have a combobox that is linked to Range = A1:A11, using the RowSource =
A1:A11 in the properties window. The problem is that I launch the combobox
in a tab, and the range A1:A11 is in another tab. Is there anyway to specify
which tab the range A1:A11 is in.

The combobox launches from a chart and the range A1:A11 are the charts you
can choose.

Thanks

--

Dave Peterson