PDA

View Full Version : Only if has value



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,

malik641
11-26-2005, 08:28 PM
If Intersect(Target, Range("C11:AG11, C22:AG22, C33:AG33")).Value <> vbNullString Then
You could try this (untested air code...beware)....not sure if you meant the intersect range or the range you specified in the "Range()" piece...