Ok, now I'm confused!

Biff

wrote in message
ups.com...
This is what I would have thought was correct (cell is K9) but I just
keep on getting an "Invalid Cell Reference" error.

=MAX(INDIRECT(K8&":K"&Q9))

When I Evaluate the formula it equates to:

=MAX(INDIRECT(";K5))

Seems strange that it contains a colon.