Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro error
I keep getting the error run-time error '1004': application-defined
object-defined error. This only happens when my row reff is 100 any other number it works fine I cna change it to 99 and it works 101 perfect. Here is the line that is giving the error. Workbooks("ODE VZBT CRMG Lvl2 AM 1.xls").Sheets("Sheet1").Range("E" & RowRef(1) & ":P" & RowRef(1) & ",E" & RowRef(2) & ":P" & RowRef(2) & ",E" & RowRef(3) & ":P" & RowRef(3) & ",E" & RowRef(4) & ":P" & RowRef(4) & ",E" & RowRef(5) & ":P" & RowRef(5) & ",E" & RowRef(6) & ":P" & RowRef(6) & ",E" & RowRef(7) & ":P" & RowRef(7) & ",E" & RowRef(8) & ":P" & RowRef(8) & ",E" & RowRef(9) & ":P" & RowRef(9) & ",E" & RowRef(10) & ":P" & RowRef(10) & ",E" & RowRef(11) & ":P" & RowRef(11) & ",E" & RowRef(12) & ":P" & RowRef(12) & ",E" & RowRef(13) & ":P" & RowRef(13) & ",E" & RowRef(14) & ":P" & RowRef(14) & ",E" & RowRef(15) & ":P" & RowRef(15) & ",E" & RowRef(16) & ":P" & RowRef(16) _ & ",E" & RowRef(17) & ":P" & RowRef(17) & ",E" & RowRef(18) & ":P" & RowRef(18) & ",E" & RowRef(19) & ":P" & RowRef(19) & ",E" & RowRef(20) & ":P" & RowRef(20) & ",E" & RowRef(21) & ":P" & RowRef(21) & ",E" & RowRef(22) & ":P" & RowRef(22) & ",E" & RowRef(23) & ":P" & RowRef(23) & ",E" & RowRef(24) & ":P" & RowRef(24) & ",E" & RowRef(25) & ":P" & RowRef(25) & ",E" & RowRef(26) & ":P" & RowRef(26) & ",E" & RowRef(27) & ":P" & RowRef(27) & ",E" & RowRef(28) & ":P" & RowRef(28) & ",E" & RowRef(29) & ":P" & RowRef(29)).Copy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro error
What is the code of RowRef?
" wrote: I keep getting the error run-time error '1004': application-defined object-defined error. This only happens when my row reff is 100 any other number it works fine I cna change it to 99 and it works 101 perfect. Here is the line that is giving the error. Workbooks("ODE VZBT CRMG Lvl2 AM 1.xls").Sheets("Sheet1").Range("E" & RowRef(1) & ":P" & RowRef(1) & ",E" & RowRef(2) & ":P" & RowRef(2) & ",E" & RowRef(3) & ":P" & RowRef(3) & ",E" & RowRef(4) & ":P" & RowRef(4) & ",E" & RowRef(5) & ":P" & RowRef(5) & ",E" & RowRef(6) & ":P" & RowRef(6) & ",E" & RowRef(7) & ":P" & RowRef(7) & ",E" & RowRef(8) & ":P" & RowRef(8) & ",E" & RowRef(9) & ":P" & RowRef(9) & ",E" & RowRef(10) & ":P" & RowRef(10) & ",E" & RowRef(11) & ":P" & RowRef(11) & ",E" & RowRef(12) & ":P" & RowRef(12) & ",E" & RowRef(13) & ":P" & RowRef(13) & ",E" & RowRef(14) & ":P" & RowRef(14) & ",E" & RowRef(15) & ":P" & RowRef(15) & ",E" & RowRef(16) & ":P" & RowRef(16) _ & ",E" & RowRef(17) & ":P" & RowRef(17) & ",E" & RowRef(18) & ":P" & RowRef(18) & ",E" & RowRef(19) & ":P" & RowRef(19) & ",E" & RowRef(20) & ":P" & RowRef(20) & ",E" & RowRef(21) & ":P" & RowRef(21) & ",E" & RowRef(22) & ":P" & RowRef(22) & ",E" & RowRef(23) & ":P" & RowRef(23) & ",E" & RowRef(24) & ":P" & RowRef(24) & ",E" & RowRef(25) & ":P" & RowRef(25) & ",E" & RowRef(26) & ":P" & RowRef(26) & ",E" & RowRef(27) & ":P" & RowRef(27) & ",E" & RowRef(28) & ":P" & RowRef(28) & ",E" & RowRef(29) & ":P" & RowRef(29)).Copy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro error
I suggest you find a better way of defining your ranges, as this is
unreadable. NickHK wrote in message oups.com... I keep getting the error run-time error '1004': application-defined object-defined error. This only happens when my row reff is 100 any other number it works fine I cna change it to 99 and it works 101 perfect. Here is the line that is giving the error. Workbooks("ODE VZBT CRMG Lvl2 AM 1.xls").Sheets("Sheet1").Range("E" & RowRef(1) & ":P" & RowRef(1) & ",E" & RowRef(2) & ":P" & RowRef(2) & ",E" & RowRef(3) & ":P" & RowRef(3) & ",E" & RowRef(4) & ":P" & RowRef(4) & ",E" & RowRef(5) & ":P" & RowRef(5) & ",E" & RowRef(6) & ":P" & RowRef(6) & ",E" & RowRef(7) & ":P" & RowRef(7) & ",E" & RowRef(8) & ":P" & RowRef(8) & ",E" & RowRef(9) & ":P" & RowRef(9) & ",E" & RowRef(10) & ":P" & RowRef(10) & ",E" & RowRef(11) & ":P" & RowRef(11) & ",E" & RowRef(12) & ":P" & RowRef(12) & ",E" & RowRef(13) & ":P" & RowRef(13) & ",E" & RowRef(14) & ":P" & RowRef(14) & ",E" & RowRef(15) & ":P" & RowRef(15) & ",E" & RowRef(16) & ":P" & RowRef(16) _ & ",E" & RowRef(17) & ":P" & RowRef(17) & ",E" & RowRef(18) & ":P" & RowRef(18) & ",E" & RowRef(19) & ":P" & RowRef(19) & ",E" & RowRef(20) & ":P" & RowRef(20) & ",E" & RowRef(21) & ":P" & RowRef(21) & ",E" & RowRef(22) & ":P" & RowRef(22) & ",E" & RowRef(23) & ":P" & RowRef(23) & ",E" & RowRef(24) & ":P" & RowRef(24) & ",E" & RowRef(25) & ":P" & RowRef(25) & ",E" & RowRef(26) & ":P" & RowRef(26) & ",E" & RowRef(27) & ":P" & RowRef(27) & ",E" & RowRef(28) & ":P" & RowRef(28) & ",E" & RowRef(29) & ":P" & RowRef(29)).Copy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
naming tab macro error runtime error 1004 | Excel Programming | |||
Macro 'Automation error' with ChemOffice Excel macro | Excel Programming |