Re: Select cell where column and row intersect.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ExcelTricks@xxxxxxxxx
Date: 3 Dec 2006 11:41:39 -0800

Thank you Don! I had to change it a little to get it to do what I want,
but it seems to work great now.

Sub asktogo1()
mc = InputBox("Enter column header")
mr = InputBox("enter row")
Cells(Columns(1).Find(mr).Row, Rows(1).Find(mc).Column).Select
End Sub

.

Follow-Ups:
- Re: Select cell where column and row intersect.
  - From: Don Guillett

References:
- Select cell where column and row intersect.
  - From: ExcelTricks
- Re: Select cell where column and row intersect.
  - From: Don Guillett
- Re: Select cell where column and row intersect.
  - From: ExcelTricks
- Re: Select cell where column and row intersect.
  - From: ExcelTricks
- Re: Select cell where column and row intersect.
  - From: Don Guillett

Prev by Date: Re: Adding items to a combo box
Next by Date: Re: Best way to use INI file
Previous by thread: Re: Select cell where column and row intersect.
Next by thread: Re: Select cell where column and row intersect.
Index(es):
- Date
- Thread