| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop every 26 rows and if..
Would appeciate VBA code for a macro that does the following:
My range from Row 2 to Row 4993 has records in sets of 26 rows each. ProceduIf Activecell (R2, Range name €śStart€ť)=0,move 16 columns left to be at B2, write €śA/C closed€ť Then move 16 columns right (back to column R), 26 rows down (R28) for next record, repeat procedure Else move down 26 rows (R28), repeat procedure And so on until last record at R4968 Thank you, -- Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop relative rows | Excel Discussion (Misc queries) | |||
| Deleting rows loop | Excel Programming | |||
| Loop through rows using a wildcard. | Excel Programming | |||
| loop to insert rows | Excel Programming | |||
| Cannot loop through rows in C# | Excel Programming | |||
Threaded Mode
