View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arle Arle is offline
external usenet poster
 
Posts: 2
Default using variables with Find

Thank you so much! I needed to add a reference to the other sheet just
in case they didn't click in the name field to begin with.

personToFind = InputBox("Enter name exactly as it appears in
column A")
Sheets("complete list").Select
Range("A1").Select