Worksheet_Change Event (If User Mouse Clicks Out of the Active Cell)

[sadclown]

I seem to be having an issue with a Worksheet_Change event. I have it setup to auto-populate a cell (using the offset method) based on a cell change. This works fine unless a user changes the value in a cell and mouse clicks to another row. When that occurs, if the column to which they move the cursor is within my bounds, it changes that row instead of the original.

Please Login or Register  to view this content.

What I need is a method by which I can reference the cell that was originally changed and perform my offset based on that value. Any ideas as to how I can store that original cell value would be most appreciated.

[AlphaFrog]

Target is the cell that was changed.

Please Login or Register  to view this content.

[sadclown]

Thank you much, I'm kind of embarrassed that I didn't think of that! Worked like a charm...