kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I want to display alert when I double click a cell within a given range.
I can show for any cell with the Target.Address but with the given range.
Now my range is F5:AJ & Last used row.
I am using column E to check the last used row.
So when I double click any cell within the range, I want it to display an alert showing the column index of my range (table).
Since my table starts with column F, any cell clicked in column F should show 1, G = 2 and so on.
Can someone help me out?
Thanks in advance.
I can show for any cell with the Target.Address but with the given range.
Now my range is F5:AJ & Last used row.
I am using column E to check the last used row.
So when I double click any cell within the range, I want it to display an alert showing the column index of my range (table).
Since my table starts with column F, any cell clicked in column F should show 1, G = 2 and so on.
Can someone help me out?
Thanks in advance.