aberenguel
Board Regular
- Joined
- Aug 10, 2006
- Messages
- 83
First off, here is the code I'm working with
Sub Load_Into_AutoSubPROCESS()
Range("N119:cb119").Select
Selection.Copy
Sheets("autsubPROCESS").Select
Range("A2").Select
Cells.Find(What:="@", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("VALT INPUT").Select
Range("N119").Select
End Sub
What I'm trying to do with this code is copy the selection from the VALT INPUT tab and paste it's values in the first available row in column A that contains "@" (within the autsubPROCESS tab). I want excel to look for "@" in column A only. Also I should note that the values in column A within the autsubPROCESS tab are coming from another tab (i.e. cell A2 = value from PIVOT tab cell A2)
For some reason I am recieving the following error message
Run-tme error '91':
Object variable or With block variable not set
Any ideas on why I'm recieving this error? It's beyond me!
Sub Load_Into_AutoSubPROCESS()
Range("N119:cb119").Select
Selection.Copy
Sheets("autsubPROCESS").Select
Range("A2").Select
Cells.Find(What:="@", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("VALT INPUT").Select
Range("N119").Select
End Sub
What I'm trying to do with this code is copy the selection from the VALT INPUT tab and paste it's values in the first available row in column A that contains "@" (within the autsubPROCESS tab). I want excel to look for "@" in column A only. Also I should note that the values in column A within the autsubPROCESS tab are coming from another tab (i.e. cell A2 = value from PIVOT tab cell A2)
For some reason I am recieving the following error message
Run-tme error '91':
Object variable or With block variable not set
Any ideas on why I'm recieving this error? It's beyond me!