Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
Each cell in an expanding named range "AnalysisRoutesList" in Col E has data validation, so when a cell is double clicked, an Information msgbox appears (OK, Cancel, Help) prompting me to double click the cell 3 columns to the left of the one I have just double clicked (Col B).
What I'd be grateful for is some code so when I double click any cell in the above named range (it expands by inserting rows within the range, not at the bottom), the cell in the same row in Col B is selected (or better still, double clicked).
(Double clicking a cell in Col B runs a search macro, but it fails to locate the correct cell fairly frequently, hence why I don't simply double click the cell in Col B - but I need to do it this way because the code associated with double clicking the cell in Col B runs perfectly every time when I double click AnalysisRoutesList cells first, then go back to Col B).
Many thanks!
Each cell in an expanding named range "AnalysisRoutesList" in Col E has data validation, so when a cell is double clicked, an Information msgbox appears (OK, Cancel, Help) prompting me to double click the cell 3 columns to the left of the one I have just double clicked (Col B).
What I'd be grateful for is some code so when I double click any cell in the above named range (it expands by inserting rows within the range, not at the bottom), the cell in the same row in Col B is selected (or better still, double clicked).
(Double clicking a cell in Col B runs a search macro, but it fails to locate the correct cell fairly frequently, hence why I don't simply double click the cell in Col B - but I need to do it this way because the code associated with double clicking the cell in Col B runs perfectly every time when I double click AnalysisRoutesList cells first, then go back to Col B).
Many thanks!