| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run- time error 1004
I have the following
Range("Z4:Z5").Select 'Copies blank cells to Country,CustomerPart NO & Contacts Email input cell Selection.Copy Range("AD10").Select Selection.PasteSpecial Paste:=xlPasteValues Application.Goto Reference:="SubstrateStandard" 'This works where "SubstrateStandard" is cell Substrate1!S1 Sheets("Substrate1").Select Range("S1").Select 'this will not work Gives "Application-defined or object-defined error oldjay |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run- time error 1004
If your code is behind a worksheet, then Range("S1") refers to the sheet with
that code--not the Substrate1 worksheet. with worksheets("substrate1") .select .range("s1").select end with or application.goto worksheets("substrate1").range("s1"), scroll:=true should both ok. Oldjay wrote: I have the following Range("Z4:Z5").Select 'Copies blank cells to Country,CustomerPart NO & Contacts Email input cell Selection.Copy Range("AD10").Select Selection.PasteSpecial Paste:=xlPasteValues Application.Goto Reference:="SubstrateStandard" 'This works where "SubstrateStandard" is cell Substrate1!S1 Sheets("Substrate1").Select Range("S1").Select 'this will not work Gives "Application-defined or object-defined error oldjay -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run- time error 1004
Thanks
"Oldjay" wrote: I have the following Range("Z4:Z5").Select 'Copies blank cells to Country,CustomerPart NO & Contacts Email input cell Selection.Copy Range("AD10").Select Selection.PasteSpecial Paste:=xlPasteValues Application.Goto Reference:="SubstrateStandard" 'This works where "SubstrateStandard" is cell Substrate1!S1 Sheets("Substrate1").Select Range("S1").Select 'this will not work Gives "Application-defined or object-defined error oldjay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
| Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
| Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
| Run time error 1004, General ODBC error | New Users to Excel | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Linear Mode
