Highlighting cells within a loop

Closed
KingTut - 24 May 2010 à 14:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 25 May 2010 à 17:20
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
25 May 2010 à 17:20
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)