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 |
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 |