Delete Row At Excel 97

J

Jason

Hi All,

I have this coding to delete a row :-

Sheet2.cells(1,1).delete

It is working on Excel 2000 by when run on Excel 97, it
prompt me this error message :-

******************************************
Run-time error '1004'
Delete method of Range class failed
******************************************

Can anyone advise me.

Thanks...
Jason
 
J

Jason

Hi Nigel,

Thanks a million for your prompt reply.

I change the coding to :-
Sheet2.cells(1,1).clearcontents

and it prompt me the similar message :-

******************************************
Run-time error '1004'
Clearcontents method of Range class failed
******************************************
I need to delete the whole row in order to let the below
number to replace the row.

Thanks and best regards,

Jason
 
G

Guest

Hi Nigel,

It is working on Excel 2000 but can't work on Excel 97.

Big headache....

Anyway thank for your advise.

Cheers...

Jason
 
Top