Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set range with Find method
The problem is with Env.
I don't see where it is Set. This does work: Sub fhskdf() Dim Con1 As Range Set Con1 = Range("A1:A65").Find("1stConverting Run", LookIn:=xlValues) MsgBox (Con1.Address) End Sub -- Gary''s Student - gsnu200817 "jlclyde" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Method problem in Excel VBA.... | Excel Worksheet Functions | |||
Autofill method of range class failed | Excel Discussion (Misc queries) | |||
How do you find the method of selected points? | Setting up and Configuration of Excel | |||
How to find method to cut steel coil by using excel. | Excel Worksheet Functions | |||
ClearContents method on a passed range | New Users to Excel |