Only if has value

[viper]

How can I change this to only if the cells in the range have a value?

[VBA]
If Not Intersect(Target, Range("C11:AG11, C22:AG22, C33:AG33)) Is Nothing
[/VBA]


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]

[VBA]If Intersect(Target, Range("C11:AG11, C22:AG22, C33:AG33")).Value <> vbNullString Then[/VBA]
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...