2 part VBA Find problem

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

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
 
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)
 
Back
Top