Highlighting cells within a loop

Closed
KingTut - May 24, 2010 at 02:33 PM
rizvisa1
Posts
4479
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!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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