Cannot paste named range formula

  • Thread starter Thread starter Robert H
  • Start date Start date
R

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.
 
The length of the formula used to define a named range must be less than 256
characters.
 
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
 
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
 
Back
Top