Entering a value into a cell by clicking

[mattsgr1]

I have written the code below so that if a cell in a particular range is selected it will enter the value é . . the code works great however if I highlight a cell within that range whilst having other cells outside the given range highlighted the value é is put into every highlighted cell regardless of whether it is in my specified range. Is there a way to stop this??

Please Login or Register  to view this content.

[loumf]

You are setting the Target to é, you want to set the intersection of the specified range and the target to é

[mattsgr1]

You are setting the Target to é, you want to set the intersection of the specified range and the target to é

What do you mean? How would I do what you said?

[mattsgr1]

I have solved the problem, for anyone that is interested...

Instead of writing: Target = é

You should write: ActiveCell = é

This stops the range selection problem