| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
R/T error 1004 - App-defin or obj defin error on last presented li
Hi Jim,
Try replacing: ActiveSheet.Range("B2:B" & Beglrow).Formula = "=IF(ISNUMBER(D2),D2,"")" with ActiveSheet.range("B2:B" & BeglRow).Formula = _ "=IF(ISNUMBER(D2),D2,)" --- Regards, Norman "Jim May" wrote in message ... Sub PrepDepsAndWiths() Sheets("ImportWorkTable").Select ActiveSheet.UsedRange.Offset(1, 0).Copy Sheets("DepositsAndWithdrawals").Range("D2") Sheets("DepositsAndWithdrawals").Activate Range("A1").Select Beglrow = Cells(Rows.Count, "D").End(xlUp).Row ' = 589 ActiveSheet.Range("B2:B" & Beglrow).Formula = "=IF(ISNUMBER(D2),D2,"")" <<Bombing here (this line) Can someone assist? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004, Application-definded or object-defined error | Excel Programming | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
| naming tab macro error runtime error 1004 | Excel Programming | |||
Threaded Mode
