Good day!
I am trying to locate the exact range.
Formula:
=ADDRESS(MAX(INDEX((A:A=F2)*ROW(A:A),0))*1,1) Result:$A$24
Need a code to search/locate "A24" once you click on it.
Good day!
I am trying to locate the exact range.
Formula:
=ADDRESS(MAX(INDEX((A:A=F2)*ROW(A:A),0))*1,1) Result:$A$24
Need a code to search/locate "A24" once you click on it.
Last edited by zelda13; 08-16-2021 at 07:17 AM.
You could use a Selection Change Event handler monitoring cell H2. And use Application.GoTo to go to the cell.
Can't give a full and tested solution as I’m using an iPad at the moment.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In H2 Cell
Formula:Please Login or Register to view this content.
Replace your current formula with the above one.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks