-
there are a few issues with your current approach:
- Range("F1:F101").Cell is not correct. To loop through each cell in a range, you need to use a For Each loop.
- The logic inside your If statements needs to be adjusted so that you're checking the color for each individual cell.
- The Cell.Value = "LS" should be inside the second If statement, but it should only be executed when the color of the cell is 15.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules