That is because after the indirect is processed, that part of the expression
becomes something like this... ROW(39667:39670)... each cell in each row
will be iterated through. How many cell are there in a row in XL2007?
Multiply that by 4... how many total cells have you asked the F9 key to
display for you?

Rick


"Dave" wrote in message
...
By the way, even if I reduce the the date range to just a few days (4),
when
I highlight <INDIRECT(A1&":"&B1) and press F9, I still get the message
"Formula is too long. Formulas may not exceed 8192 characters."
If I highlight <ROW(INDIRECT(A1&":"&B1)) or
<DAY(ROW(INDIRECT(A1&":"&B1)))
and press F9, the result makes sense.
(Yes, XL2007)
Regards - Dave.