Good afternoon all,
Oh, this simple code is doing my head in!
I can find HEAPS and HEAPS of examples to get the maximum value in a column, but for the life of me can not seem to rejig the code to look at another sheet other than the one I am working in.
Here is what I have that works so far:
What I am after is to look at the maximum value from a sheet called FOI Records and show me the value + 1
I have toyed with many ways I know of to point this simple code's range to the sheet I want, but AGHHHH I just can't nab it.
Can anyone help .. please?