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