Hi ng
Using xl 2003

Attempting to build ordering system so satellite operations can ente
their orders from remote sites.

Commissary will open master to pull in all satellite orders t
determine total need for purchasing, production, distribution.

I have 52 named ranges spanning 3 worksheets
Each range contains 7 days
Protocol: Ordw1, Ordw2, etc...

Working so when opened, all hidden except first 4 columns fo
informational.

User provided form with listbox to choose week to work with
Based on selection appropriate range should be unhidden.

Questions:
I don't see a hide or unhide method for Range. Am I missing something
Is there a better way to accomplish the task?

Is spanning across 3 sheets with diff names the best approach?
I need 365 columns but maybe only 200 rows

Would it be better to drop next set of ranges at row 400

--
Message posted from http://www.ExcelForum.com