Hi All,
I'm experimenting with Macros with my work, I've never used macros before but use if's and nested if's all the time and someone said this may be easier. I just tried a really basic one and it's not working correctly;

I just did the "record macro" in OOo. What I recorded:

=if(L3<50; L3+1900; L3)

as you can see, quite basic. Now it saves it correctly and the function worked BUT when I try to run the Macro fro the next one it uses L3 again instead of using the next cell (L4). If I just drag the cell all the way down it auto adds 1 to LX so it works like a charm. I'd also like to get this done because I'm a supervisor on a research project and...some of the other researchers that I'm in charge of aren't great with creative thinking for functions so if I could just give them macros to work with that would be great. This thread may be long as I start to do some of the nested ifs and iffs and all the other fun stuff I'm having to do Thanks all!