Execute macro on cell value change

Hi guys I need your help once again!

I have the following code:

Please Login or Register  to view this content.

Its basically just to change the formatting of a cell when the value is entered so that it shows up if the value is very small (the value of the cell can range from 10^6 to 10^-9).

However when you change the value of the cell, the macro runs off the cell that you selected afterwards (i.e. if you click off the cell then it takes the value of the cell you selected next, or if you press carriage return to leave that cell then it takes the value from the cell below) what is the way to stop it doing this? I tried surrounding my code in an

Please Login or Register  to view this content.

code but that seemed to make no difference?

Any help is greatly appreciated

Regards

Tom

Hi Tom,

I couldn't get it to work by finding the last active cell.

But I do have an alternative that should do the trick, using a loop to format every cell within the range.

Please Login or Register  to view this content.

Let me know if this works for you!

Owen

That worked a treat! Thanks mate