Don't post attachments: no-one will read them. Paste the code into the
message body - work on line breaks as required.

Tim

"Gary Keramidas" wrote in message
...
ok, here it is. i used an attachment to help with line breaks

--


Gary


"Gareth" wrote in message
...
Go ahead and post it. I'm sure someone will be able to take it on.

Gary Keramidas wrote:
i have a routine i wrote to add a range to an exiting formula. it
has 24
formulas on 12 sheets hat need to be updated. the linked cells are
an
external workbook with a sheet called branch.

the routine takes about a minute and a half to execute, but it
will only
execute when a new person is added, couple times a year.

it is about 50 lines including the dims. is it appropriate to post
it so i
can ask someone if there is a more efficient way?

thanks