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

you are using the Cells without the parent worksheet name. Use it as

Worksheets("Sheet1").Cells

Mangesh



"lehainam" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> you are using the Cells without the parent worksheet name. Use it as
>
> Worksheets("Sheet1").Cells
>
> Mangesh
>
>
>
> "lehainam" <[email protected]> wrote
> in
> message news:[email protected]...
>>
>> 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
>>
>
>

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" <[email protected]> wrote in message
news:e8SzoY#[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > you are using the Cells without the parent worksheet name. Use it as
> >
> > Worksheets("Sheet1").Cells
> >
> > Mangesh
> >
> >
> >
> > "lehainam" <[email protected]> wrote
> > in
> > message news:[email protected]...
> >>
> >> 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
> >>
> >
> >
>
>

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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> you are using the Cells without the parent worksheet name. Use it as
>
> Worksheets("Sheet1").Cells
>
> Mangesh
>
>
>
> "lehainam" <[email protected]> wrote
in
> message news:[email protected]...
> >
> > 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
> >
>
>

Hi Lehainam,

Please post your problematic code.


---
Regards,
Norman



"lehainam" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>