MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert Excel 2000 line in macro to 97

Posted by Ben on April 07, 2001 12:27 PM

The line 'cell.EntireRow.Delete' works in Excel 2000, but when I try to use it in a macro for Excel 97 it doesn't work.

Could anyone please tell me another line that could replace this one and works in both Excel 97 & 2000.


Posted by Dave Hawley on April 07, 2001 2:14 PM

Hi Ben

Assuming you have dimensioned "Cell" as a Range variable and your using it in the right context it should work exactly the same in 97 as it does in 2000. Perhaps your problem lies elsewhere ?

OzGrid Business Applications

Posted by Ben on April 08, 2001 2:54 AM