View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ExcelTricks@gmail.com is offline
external usenet poster
 
Posts: 4
Default Select cell where column and row intersect.


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