Highlighting cells within a loop

Closed
KingTut - May 24, 2010 at 02:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2010 at 05:20 PM
Hello,

I am trying to set my vb code to highlight columns C through G in a light blue color after each step of the loop. So for instance my for statement is pulling email addresses from a cell in column G and then sending an email with the same file saved and then attached. I want the row that the email address is on to be highlighted from C to G and THEN sent to the email recipient in column G. And so on for each new cell in the conditional statement. Any ideas? Thanks in advance!

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 25, 2010 at 05:20 PM
Use macro record to do this. You will get the code for highlighting the rows/range

some thing like

range("A1:F1").interior.color = rgb(255,0,0)
0