Is there anyway to start the MOD function on a specific row? My current excel file I have the following code:
If ccells.Row Mod 5 <> 0 Then
Select Case ccells
I have other code set to color columns based off of text entered in all rows except the ones the MOD function applies to. The MOD function applies to every 5th row, which currently works, but I am making a change in my rows that will change the function from 5 to 4, but it still starts on the 5th row as before. Can you tell VBA on what row to start the function, or is there another way?
If ccells.Row Mod 5 <> 0 Then
Select Case ccells
I have other code set to color columns based off of text entered in all rows except the ones the MOD function applies to. The MOD function applies to every 5th row, which currently works, but I am making a change in my rows that will change the function from 5 to 4, but it still starts on the 5th row as before. Can you tell VBA on what row to start the function, or is there another way?