| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Method 'Range" of object'_Global' failed
I get this error when i try to run, how could i place variables in the selection Sheets("Eclipse").Selec Range("A1").Selec Cells.Find(What:="wopr", After:=ActiveCell, LookIn:=xlFormulas, LookAt :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= False).Activat Cells.Find(What:="7p2", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) .Activat x = Cells.Find(What:="7p2", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) .Activat y = Selection.End(xlDown).Selec Range("A$x:A$y").Select <-----------------------------------------------------------------Problem lin Application.CutCopyMode = Fals Selection.Cop Sheets("Sheet1").Selec Range("D2").Selec ActiveSheet.Past End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
| Autofill method of range class failed | Excel Discussion (Misc queries) | |||
| "method 'execute' of object 'find' failed" | Excel Discussion (Misc queries) | |||
| Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
| "Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming | |||
Threaded Mode
