Please help!

[Benny]

I am working on an Excel spreadsheet and I am using a formula which works in one column, but not others. The formula is the same in each cell that I am applying it to, but for some reason it will only work in some columns.

Any ideas why anybody? Please help.... : -)

Benny

[degsy]

Would be handy if you posted the code

[Jonesy]

Check your formula for "$" signs. If you have them then you are creating absolute references, which will yield symptoms similar to what you have.

And yes ... you should post copies of the formulae so we can see what's really there.

Jonesy