If I understand correctly, you have something that you need to change in
a bunch of different cells to a different formula? If so, this is a
little quicker but it won't do them all at once (I'm not sure how to do
that). But if you change the formula in one cell, then highlight that
cell, use format painter (the little paintbrush on your toolbar) and
highlight the new cell you wish to put the formula in. The only thing
is that it will completely change any formats you have in the other
cell if they are different, so hopefully they are the same. I'm not
sure if this will work either, but I know in word, if you highlight
something and press either shift or control, you can highlight multiple
items. Try to use that to format paint all at once. Again, not sure if
it will work, but I hope so!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=495231