What does "does not seem to work" mean to you?

If c is declared as a Range or Variant, your code should work.



In article ,
wrote:

Hello,

I have a worksheet that I rely on the change event to alter data entered
into cells. Is there a way to have code loop through each cell in the
target.value?

IE:

for each c in target

do stuff...

next c

This does not seem to work for me but the concept is what i am looking
for... Any ideas?

Thanks,
Ernst.