View Single Post
  #3   Report Post  
Hrwilkers Hrwilkers is offline
Junior Member
 
Posts: 4
Default

This works, but only for one cell. I need it to work for the entire column from B2 down. My guess is I need to use a range and modify this line, but can not figure out what to modify it with:
If Target.Address < "$B$1" Then

How do I modify this to apply to all of column B from B2 down? Thanks. Hrwilkers