Cannot paste named range formula

[Robert H]

Im trying to paste a formula in a named range and when I paste nothing
happens. I thoiught I was copying incorrectly but I can paste dat and
formulas from other cells. This formula is roughly three lines long in
the worksheet formula bar. Does the named range formula have a more
restrictive maximum length than a cell? If so Ill have to break this
up.

 

[T. Valko]

The length of the formula used to define a named range must be less than 256
characters.

 

[Robert H]

Thanks Biff, It. was a giant IF function. I ended up splitting the
formula in to separate Test, True, and False sections each with its
own name. the formula "UseList" is now IF(UseslistTest, UseListTrue,
useListFalse).

Robert

 

[T. Valko]

Glad you got it worked out.

The 255 character limit in refedits (those little boxes where you enter
references/formulas) is a pet peeve of mine. I think the limit should be the
same as a worksheet cell formula.

--
Biff
Microsoft Excel MVP


Thanks Biff, It. was a giant IF function. I ended up splitting the
formula in to separate Test, True, and False sections each with its
own name. the formula "UseList" is now IF(UseslistTest, UseListTrue,
useListFalse).

Robert