View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Extending sub to cover other target cells

Thanks, bpeltzer !
That works great.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"bpeltzer" wrote in message
...
Instead of
If Target.Address = "$C$2" Then
use
If ((Target.Column = 3) And ((Target.Row Mod 23) = 2)) Then
(This uses steps of 23 per the cell addresses listed; if you need the

last
matching cell to be C94, you could further qualify it with "And

(Target.Row
<= 94)" ).