View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Set range with Find method

Dim Env As Worksheet
Env.Activate
Dim Con1 As Range
Set Con1 = Env.Range("A1:A65").Find("1stConverting Run",
LookIn:=xlValues)
I am trying to set the cell that is found as the range Con1. What is
wrong with this?

Thanks,
Jay