| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 part VBA Find problem
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 part VBA Find problem
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) "jlclyde" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find last name in multi-part name? | Excel Worksheet Functions | |||
| How do I use VLOOKUP to find part of string? | Excel Worksheet Functions | |||
| Find part data in row range? | Excel Worksheet Functions | |||
| Find part of a word in cell | Excel Discussion (Misc queries) | |||
| Find and copy part of a cell | Excel Worksheet Functions | |||
Linear Mode
