s I said, I had to make assumptions as I don't know what format_over_105
does, but it would seem that it expects a cell(s) reference.
Range("C1").Cells is such, but by enclosing it within parentheses, the
expression was being evaluated before being passed to the routine, hence it
was a value being passed, not the cell(s) reference. The brackets have a
purpose in a call statement, they are not just ways to organise the
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Tara H" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...