Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run-time error '1004':
I'm getting a really hard error when I code to put a formula into a worksheet
that works as a normal formula in the worksheet. I'm building 500 tables (worksheet B) that contain detailed breakdown data for each single entry in another worksheet (Worksheet A). So for each Worksheet A entry there is a detailed breakdown table. I'm trying to write code to create the remaining 499 other tables. This is a one time use of code (vice creating each one manually that cannot be done by recording a macro and running it) to save time. I'm stuck on this: Run-time error '1004': Application-defined or object-defined error The code above this works fine but this generates the error: 'Now Fix the Formulas for Effort Hours Worksheets("Data-Tables").Range("F" & (STARTCELL + (OFFSET * _ LoopCounter) + 3)).Formula = "=IF(Utilize_Nominal_Estimate, _ IF(ISERROR((((E626/$E$617)*$C$565)*Sizing!$Z$6)), 'No Entry', _ (((E626/$E$617)*$C$565)*Sizing!$Z$6)), _ IF(ISERROR((((E626/$E$617)*$C$565)*Sizing!$O$6)), 'No Entry', _ (((E626/$E$617)*$C$565)*Sizing!$O$6)))" I had to break this line up a little more to make it readable here. If I don't use the ISERROR code the thing runs fine. However, with it the code crashes. I've started with the formula copied of the worksheet that already works start using loopcounters, offsets, and such to fix the hard references to point the the right cells. Any ideas? Thanks, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions |