I have just tried the formula on a blank sheet. it works fine.

When i ad it to my existing sheet, into my scrolling coloumn it doesnt work so well.

Any ideas?

Your help would be much appreciated

Joel