Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run the following code but I am getting a "Run-time error
'1004': Application-defined or object-defined error" on line: c.Offset(0, i).AddComment.Text c1.Offset(0, i).Text I can't figure out what I'm doing wrong, or what is wrong. Any help will be greatly appreciated. Set oldWs = Worksheets("OLD") oldWs_lastRow = oldWs.Range("C65536").End(xlUp).Row Set newWs = Worksheets("NEW") newWs_lastRow = newWs.Range("C65536").End(xlUp).Row For Each c In newWs.Range("C2:C" & newWs_lastRow).Cells For Each c1 In oldWs.Range("C2:C" & oldWs_lastRow).Cells If c = c1 Then For i = 1 To 66 If c.Offset(0, i) < c1.Offset(0, i) Then c.Offset(0, i).AddComment.Text c1.Offset(0, i).Text End If Next i End If Next c1 Next c |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming |