Just a correction...

This formula:
=INDIRECT(IF(width=0.7,"range1","range2"))
can be:
=IF(width=0.7,range1,range2)

No need for that extra junk.

Dave Peterson wrote:

Do you have to use a combobox?

How about a cell with Data|Validation?

Then you could use List with a source:
=INDIRECT(IF(width=0.7,"range1","range2"))
(notice that the range1 and range2 names are surrounded by quotation marks.)

PCH wrote:

I have a combobox on a work sheet.
I want to set the input range depending upon an if statement...

Input range =if(Width=0.7,Range1,Range2)

typing this statement into the input range does not work.

How can I achieve this?

regards

Wayne

--

Dave Peterson

--

Dave Peterson