Macro time out error

G

Guest

Hello,

I have a macro that I have been using for 6 or 7 months and it was working
fine. Today it had a run time error for no reason that I can see. I also
use this another macro just like it except a different sort number. It is in
windows 2000 with excel 2000. Here is my macro:
Sub Macro1()
'
' Macro1 Macro delete min vol data in col L
' Macro recorded 4/15/2005
'
Range("L1").Select
Do Until ActiveCell.Value = ""
If ActiveCell.Value < 90 Then
z = ActiveCell.Row
Rows(z).Delete
ActiveCell.Offset(-1, 0).Select
Else
End If
ActiveCell.Offset(1, 0).Select
Loop
End Sub
'

Any ideas why this happens? I tried deleting other tabs in my spreadsheet
in the past and that has worked?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top