VBA for largest cell + 1 inserted below largest cell

**MFreak** · 11-06-2016, 12:43 PM

I need to be able to identify the largest cell in a column and insert its value plus 1 to the cell directly below it. I'm sure this is doable, but have very little experience with Macros. I need this to work from a static button. Any ideas? I can supply more info if needed.

**alansidman** · 11-06-2016, 01:53 PM

Assume your values are in Column A. This macro will put the value in the row below the last value in that row.

Please Login or Register  to view this content.

VBA for largest cell + 1 inserted below largest cell

LinkBack

Thread Tools

Rate This Thread

Display

VBA for largest cell + 1 inserted below largest cell

Re: VBA for largest cell + 1 inserted below largest cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help choosing largest or 2nd largest amount of consecutive 0's if a criteria is met

Finding largest value and second largest in a subset of data.

Largest discrepancy between two values in one range (index/match/indirect/largest/max)

Retrieving the column header for the largest or second largest value in a row

Returning Max value, 2nd largest, 3rd largest, etc without duplicates

[SOLVED] VBA to Find Largest and 2nd and 3rd Largest Value of each Rows

Update cell value based on largest corresponding cell for each unique item

Bookmarks

Bookmarks

Posting Permissions