View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default Address of Cell that lost focus?

I'm trying to set a default value for a column using VBA and am running code
when the Worksheet_SelectionChange is fired, the problem is that the Target
value is the Value of the cell that just got the focus, how do I get the
address of the cell that just lost focus?