Hi

I've just built your code into a clean book - and your code works fine - placing the total once at the bottom of column L and then copying it to the right to column B

So - either you are using Excel 97, you are hitting the macro button twice, your code is inside a loop or the total is coming in from the import routine..