viper
11-26-2005, 07:44 PM
How can I change this to only if the cells in the range have a value?
If Not Intersect(Target, Range("C11:AG11, C22:AG22, C33:AG33)) Is Nothing
Right now it only does what I need if a cell in that range is changed, but I don't need it to if it already has a value.
Thanks,
If Not Intersect(Target, Range("C11:AG11, C22:AG22, C33:AG33)) Is Nothing
Right now it only does what I need if a cell in that range is changed, but I don't need it to if it already has a value.
Thanks,