I am not sure of what you are trying to do.. It is always better to upload sample workbook to illustrate your issue well
As for dealing with whole column you could replace this line
With this line![]()
If Target.Address = "$C$2" Then
This will allow you to deal with any cell in column C not only C2![]()
If Not Intersect(Target, Columns(3)) Is Nothing Then
Hope this will help you
Bookmarks