View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Find variable in a sheet

This cannot be hard. I don't know why I can't figure it out.

I am assigning a value to a variable based on a sheet named Rep and then I
want to find this value in another sheet, Map.

I tried using the Cells.Find(What:=VariableName, etc.) but it chokes on me.
I verified the variable is populated properly by using a message box. What is
the code to find a variable? Ack!