| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Error Help!
Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
you are using the Cells without the parent worksheet name. Use it as
Worksheets("Sheet1").Cells Mangesh "lehainam" wrote in message ... Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
Hi Mangesh,
you are using the Cells without the parent worksheet name. Use it as Worksheets("Sheet1").Cells If Cells were used without explicit qualification, it would represent a range object referring to all the cells on the active sheet. Therefore, lack of qualification should not, per se, cause an error. If the active sheet were not a worksheet, then I would anticipate a 1004 run-time error rather than the OP's reported error. --- Regards, Norman "Mangesh Yadav" wrote in message ... you are using the Cells without the parent worksheet name. Use it as Worksheets("Sheet1").Cells Mangesh "lehainam" wrote in message ... Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
Hi Norman,
quite true indeed. I did a small test, and with a chart as the active sheet and using the Cells() without the parent sheet, I get a run time error 1004, method cells of object global failed. Thanks. Mangesh "Norman Jones" wrote in message ... Hi Mangesh, you are using the Cells without the parent worksheet name. Use it as Worksheets("Sheet1").Cells If Cells were used without explicit qualification, it would represent a range object referring to all the cells on the active sheet. Therefore, lack of qualification should not, per se, cause an error. If the active sheet were not a worksheet, then I would anticipate a 1004 run-time error rather than the OP's reported error. --- Regards, Norman "Mangesh Yadav" wrote in message ... you are using the Cells without the parent worksheet name. Use it as Worksheets("Sheet1").Cells Mangesh "lehainam" wrote in message ... Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
Dear all, Thanks for your help. Please find the attached file for your reference. In this Workbook, I am standing in 'JI' sheet I click 'Save Data' to copy data from this worksheet to 'Data' worksheet. The error will occur. Your help is appreciated. Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
Hi Lehainam,
Few in this newsgroup will open attachments. Post your code and indicate where the error is occurring in the code. --- Regards, Norman "lehainam" wrote in message ... Dear all, Thanks for your help. Please find the attached file for your reference. In this Workbook, I am standing in 'JI' sheet I click 'Save Data' to copy data from this worksheet to 'Data' worksheet. The error will occur. Your help is appreciated. Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
If it is not what Mangesh suggests, post the code for us to see.
-- HTH RP (remove nothere from the email address if mailing direct) "Mangesh Yadav" wrote in message ... you are using the Cells without the parent worksheet name. Use it as Worksheets("Sheet1").Cells Mangesh "lehainam" wrote in message ... Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Error Help!
Hi Lehainam,
Please post your problematic code. --- Regards, Norman "lehainam" wrote in message ... Dear all, I have a code in Excel and whenever I run the program there is an error: Method 'Cells' of object '_Worksheet' failed and error number is -2147417848 Could any one can help me or if I have the error number how can I get help on line (which website I can access) Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=395524 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
![lehainam[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
