Method 'Cells' of object '_Application'failed

**excel2010** · 08-28-2009, 01:22 AM

dear user
i have open exsisting excel in following code and read the first cell in excel.

Please Login or Register  to view this content.

but display the following error

runtime error 1004
Method 'Cells' of object '_Application'failed

thanks:

**D_Rennie** · 08-28-2009, 02:20 AM

I dont get the same error Do you have the code in "This workbook"

You could try.

Please Login or Register  to view this content.

Please when you post on the forum can you wrap you code in code tage, It makes it a lot ease for people to read and copy.
You can do this by placing [code ] at the start of the code and [/code ] "without the spaces

Hope this helps

**Andy Pope** · 08-28-2009, 04:07 AM

The error is because the application object does not have a cells property.
Worksheets and ranges have a cells property.

Edit: As lecxe correctly points out Application does have a Cells property. It refers to the activework books activesheet.
So note to self. Don't test lines of code without first opening a workbook.

**lecxe** · 08-28-2009, 05:48 AM

Hi excel2010

Please Login or Register  to view this content.

The Cells property of the Application object refers to the cells in the active sheet.

You get an error if the active sheet is not a worksheet.

I guess that in your case the active sheet when you opened the file was a chart sheet.

You should change this statement and specify the worksheet, for example like D_Rennie suggested or using a worksheet name.

HTH