Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Visual Basic Run-time error '1004' No cells were found
I have a user that created a spreadsheet containing VBA. Whenever someone
else opens this spreadsheet and runs the macro it works fine. On his computer, he get's this error message: Microsoft Visual Basic Run-time error '1004' No cells were found Sometimes Excel will say "Not Responding". This problem just recently started happening. It was working fine before. Eventually, after retrying and retrying the macro will work. He was getting an error before but I don't know if it is related: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10016 Date: 7/26/2005 Time: 9:38:36 AM User: DAVID-TP50145\IWAM_DAVID-TP50145 Computer: DAVID-TP50145 Description: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {0C0A3666-30C9-11D0-8F20-00805F2CD064} to the user DAVID-TP50145\IWAM_DAVID-TP50145 SID (S-1-5-21-1653462319-2826650621-2974146706-1012). This security permission can be modified using the Component Services administrative tool. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. I have since fixed this problem but his Excel issue is still there. Please let me know if you can help. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Visual Basic Run-time error '1004' No cells were found
What does the macro do?
Tim -- Tim Williams Palo Alto, CA "Paul Riker" wrote in message ... I have a user that created a spreadsheet containing VBA. Whenever someone else opens this spreadsheet and runs the macro it works fine. On his computer, he get's this error message: Microsoft Visual Basic Run-time error '1004' No cells were found Sometimes Excel will say "Not Responding". This problem just recently started happening. It was working fine before. Eventually, after retrying and retrying the macro will work. He was getting an error before but I don't know if it is related: Event Type: Error Event Source: DCOM Event Category: None Event ID: 10016 Date: 7/26/2005 Time: 9:38:36 AM User: DAVID-TP50145\IWAM_DAVID-TP50145 Computer: DAVID-TP50145 Description: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {0C0A3666-30C9-11D0-8F20-00805F2CD064} to the user DAVID-TP50145\IWAM_DAVID-TP50145 SID (S-1-5-21-1653462319-2826650621-2974146706-1012). This security permission can be modified using the Component Services administrative tool. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. I have since fixed this problem but his Excel issue is still there. Please let me know if you can help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(ERROR) Microsoft Visual Basic: 400 | Excel Discussion (Misc queries) | |||
Run-time error '1004': No cells were found | Excel Programming | |||
Run-time error '1004': No cells were found | Excel Programming | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) | |||
Excel-Microsoft Visual Basic File Not Found | Excel Programming |