Sorry Bob, I don't understand your reply, do you have a suggestion how to
solve my problem ?

"BOBF" wrote:

Note how you can combine 2 or more values into a single
string variable, which then slots into your formula. I use
a similar technique to automatically select the number of
rows of data present - it varies every day - prior to
printing. bobf
-----Original Message-----
As far asI know, it cant be done, you need to change the
sheet names
manually. I would however be delighted to be proved wrong!
Regards,
"JG" wrote in message
...
I need to copy the formula "=IF(MAX(Sheet2!B5:B200)
(TODAY()-21),"not
due","due") in sheet1 from cell b2 to all the cells
between b3 and b200.
Each
cell should refer to a new worksheet, ie b3 refers
Sheet3, b4 to Sheet4
and
so on. When I try to fill it in or copy and paste, only
the cell range
changes, and I don't seem to be able to relate it to
the sheets required.

I'd be grateful for any help please

JG


.