Thread
:
Select cell where column and row intersect.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett