Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code almost does what I need, but I'm stuck.
When I run this each cell that matches increments by two. I want to keep the same value for the whole row. Then drop a row and increment by two on the next row. Example: (Do not want) Pack112 Pack114 Pack116 (Do want) Pack112 Pack112 Pack112 Pack114 Pack114 Pack114 i = 112 For Each CELL In Range("A1:DD267") If CELL.Value = "PACK" Then i = i + 2 CELL.Value = "PACK" & CStr(i) If i 140 Then i = 0 End If Next CELL Thanks ![]() --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Incrementing Rows and Columns | Excel Discussion (Misc queries) | |||
Incrementing numbers problem | Excel Worksheet Functions | |||
fill down formula incrementing by every 12 rows | Excel Discussion (Misc queries) | |||
Incrementing formula by two rows | Excel Worksheet Functions | |||
Automatically 'incrementing' formulas for new rows. | New Users to Excel |