How did you type it in?

sheet1!a1:a10
should work
or
'sheet 1'!a1:a10



"Patty via OfficeKB.com" wrote:

Is it possible to create a combo box from data that's in another tab?
I have a combo box that's from data in hidden columns. But now I need to move
all that hidden data to another tab in the same file. But when I go into
properties and go to the ListFillRange option, it won't let me enter another
tab name.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

--

Dave Peterson