Locating an Excel combo box range

[ryan]

I am working on modifying a project in excel someone else completed.
The project contains several "combo boxes" or what I call drop-down
boxes. I've learned through looking in the "format control box" that
the list sets for these drop down menus are taken from a specific
range somewhere in the project. However I am unable to locate where
this range is. The project contains 2 tabs or sheets which contain no
sign of the range used for these drop down menus. The range for one of
them is "rates!$O$10:$O$14". There is nothing that even resembles a
table or sheet labeled "range". I've tried searching for the word
"rates" and using the "goto" command in the edit menu with no result.
When I click in the formula bar with the above range I had hoped to
see a color coded link to the range on either of the two sheets but
have not. The document is completely self reliant and as far as I can
tell is not referencing to any other excel workbook as I have isolated
the file on several machines. I'm not very advanced in excel and would
appreciate anyones wisdom in locating the origins of this mysterious
range which would allow me to change the contents of these drop down
boxes. Thanks for any help.

 

[DDM]

Ryan, quite likely the "Rates" worksheet is hidden. Try Format > Sheet >
Unhide.

 

[Bob Phillips]

it might be very hidden in which case you have to go into the VB and unhide
it.

Alt-F11 to go into the VBE
In the immediate window type
Worksheets("rates").Visible = xlSheetVisible

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ryan]

success thanks for the help!!!

Ryan, quite likely the "Rates" worksheet is hidden. Try Format > Sheet >
Unhide.