Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to find the maximum value in columns N, Y, AJ, AW, BH, BS and CD
It can from 1 to 10, depending on th value I want to insert a row below. I had thought of starting it sometrhing like this: For Each cell In Range("A2:A" & Range("A65536").End(xlUp).Row) 'find the max minus 1 cell.offset(1,0).resize(max minus 1,1).EntireRow.Insert Next cell I cannot work out the code to calculate the max -1 figure. Any help gratefully received. Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Code | Excel Worksheet Functions | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
How to insert code | Excel Discussion (Misc queries) |