Formula to show last activated cell in an array

[ardykav]

I have an array of cells B4:E4, I was wondering is there a formula or some code which will populate cell G4 with the last cell I have activated within the array. So once I click any of the cells in the array of B4:E4 cell G4 will change with some form of identifier, let’s say 1 for B4, 2 for C4 and so on

thanks

 

[Fluff]

You're welcome & thanks for the feedback.