Delete Row At Excel 97

[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

 

[Nigel]

Try Clear or ClearContents instead of delete.

Cheers
Nigel

 

[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

 

[Nigel]

Then try

Sheets("Sheet2").Cells(1,1).Delete

Cheers
Nigel