Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 error
I have the following piece of code. The Msgbox prints correctly, whereas the
very next line gives the error: 1004: Application defined or object-defined error Private Sub Worksheet_Change(ByVal Target As Range) myRow = Target.Row MsgBox Cells(myRow, "E") ' prints the message correctly. Cells(myRow, "E") = "=$E$3" ' throws the error Anybody has any idea why I am getting this error. -- - Mangesh ------------------------------------------ Office 2003 & Windows XP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Run time error 1004 General ODCB Error | Excel Programming | |||
Application Run Time Error 1004 and Stack Error | Excel Programming |