View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Select cell where column and row intersect.

something like

Sub asktogo()
mc = InputBox("Enter column")
mr = InputBox("enter row")
Range(mc & mr).Select
End Sub

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Hello everyone. I wish to be able to enter in a column header and a row
label, and be taken to the cell where they intersect. Headers are in
row 1, and row labels are in column A. I have used VBA a little, but I
need to know which module to use. Can you help me on this? Thanks!