Calling the last modified cell.

Larrynho
06-30-2010, 01:44 AM
Heya !!

Is there any way to call the last modified cell in a woksheet_change event??

I got a BIG table ( 60k rows ), and I have a worksheet _change event on that sheet... sometimes 1 value gets manually modified, and I need to run some code on that value... is there any way to call it without re-checking all the table ???

Colin Legg
06-30-2010, 02:08 AM
Target references the range being changed. Is that the one you want or do you want the previous range that was changed?

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox Target.Address
End Sub

Larrynho
06-30-2010, 02:21 AM
I tryed to meant the last one changed... but I can manage with this Target thing I think... thank you very much !!!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum