>Naomi
>
>I've incorporated this in my system and it works a treat. I guess, both from the other contibutors' comments, and my exprerience with the different techniques, this worked out certainly the fastest, as it makes use of the code already written, which EXPORTs to XLS, quicker than the copying and pasting to sheet ranges.
>
>Great, thanks.
>
>Thanks again to the others - their contibs are all stored away for future use.
>
>Mind you, I've still got to put the functions in the cells yet - next task.
>
>Terry
>
>
Glad to help by the help of Craig Boyd and others <g> As for the formula, I don't think it's a problem. Once your spreadsheet is created, you can open it and add a formula using automation. Someone from this thread (Srdjan?) already posted the solution.
If it's not broken, fix it until it is.
My Blog