Hi all,

I'm getting a little frustrated (!!)

I have some formulas, quite simple ones, that excel randomly keeps changing for no apparent reason. i.e.

=(COUNTIF(Data!E2:E279, "t1"))+(COUNTIF(Data!I2:I279, "t2"))+(COUNTIF(Data!M2:M279, "t3"))+(COUNTIF(Data!Q2:Q279, "t4"))+(COUNTIF(Data!U2:U279, "t5"))

Where the cell reference is E279 - this didn't use to say this. It said E679, I679 etc. AFter I have run the macros that perform the necessary formulae, excel magically changes the cell reference. I have no idea why or how. Does anyone have any ideas how to fix this or why it is doing it? Or at least how to prevent it.

I am meant to be using this spreadsheet at work tomorrow, and with this issue, I can't!! Is it possible instead of e2:e679 to say e2:the last row of data in column e?

Many thanks - please let me know if you need more information. And I promise Ihaven't changed it and forgotten or that any other macro intereferes with them!!!