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
|