Target.Adress how to.

[mmartinez13]

I currently have this:

If Target.Address = "$E$9" Or Target.Address = "$E$17" Or Target.Address = "$E$25" Or Target.Address = "$E$9" Then

After E9 is highlighted, I print a label. What I would like is when cells E17, E25, E33, E41, E49,............. I would like labels printed also.

Basically my users are scanning data which enters cells in columns A through E. Once the data is scanned in cell E, I return back to cell A. Once I get to E9, I want to print a label. Once I get to E17, I want to print a label, and every 8th cell down the column.

If you can't tell, I am quite the beginner. Thanks for all the replies/help. You guys are great.

 

[AlphaFrog]

Try something like this...

<font face=Courier New>    <SPAN style="color:#00007F">If</SPAN> Target.Column = 5 And (Target.Row - 1) Mod 8 = 0 <SPAN style="color:#00007F">Then</SPAN><br>        <SPAN style="color:#007F00">' Do something here</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN></FONT>

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=575995

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).