repeating a formula

hi

i have a large spreadsheet and i have entered a relative formulae in a lot of cells and due to the vast number of calculations it is slowing down the spreadsheet almost so that it stops and appears to freeze the screen

i have been advised by a member on here to write some code to repeat the calculations, but not sure where to start

any pointers

thanks

hi dave

yes the calculations have always been slow

the file is 3.2MB and zips down to about 460 KB still to big for this forum but i can email it to you if you let me have your email address

i have posted this thread already but i can let you know any information you need, will find my original thread and let you know

thanks

hi dave

the original thread is under 'invoice and hours' in excel programming

hope you can help

thanks again

hi dave

that site doesnt seem to want to work

it would be easier to email it to you?

thanks again