Timeline for VBA code that skips a row instead of "For Each row In rng.Rows"
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 1, 2019 at 10:43 | vote | accept | Caroline | ||
| Mar 1, 2019 at 10:41 | comment | added | Caroline | Thank you for the quick reply. I added your code and changed If cell.Value = "ja" And (cell.Offset(0, 9) = "meenemen") Then... to If cell.Value = "ja" And (cell.Offset(0, 9) = "meenemen") Or (cell.Offset(1, 9) = "meenemen") Then... and now it works like a charm. Perfect, thank you verg much! | |
| Mar 1, 2019 at 9:37 | history | answered | Stormweaker | CC BY-SA 4.0 |