2 part VBA Find problem

[jlclyde]

I have a worksheet where I need to find the Maximum value in a range
and add one to that number and add it at the bottom of my range.

At some later point I will be bringing information back to this
worksheet and i will need to find that number and place data into
cells on the same row.

If any one can help with these two problems, it woudl be greatlly
appreciated.
Thanks,
Jay

 

[Bob Phillips]

rng(rng.Count).Offset(1, 0).Value = Application.Max(rng) + 1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)