I attatched a copy of the worksheets I have been using, for some reason when I put it in there it doesnt work, but i can take a new plain worksheet and put some dummy numbers and a formula in there and it works.
Bill test.zip