Can you change the Target reference in Change_Event sub???

I have three columns of data that I need to all be numbers. I've figured out how to check there all numbers. but what I need to do is check if the target is in column 1 and if not change the target to be in column one. this is because I have another function which is called up but relies on it being called to the first column due to off set references in the function.

Any ideas?

hope that makes sense



Thanks

This is the code I have so far, but cant figure out how to change the target range and not sure if it is recognising input into column 2 or 3!

Please Login or Register  to view this content.

Thanks