Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 05, 06:18 PM posted to microsoft.public.excel.worksheet.functions
mike b
 
Posts: n/a
Default Macro time out error

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?

--
Mike B

  #2   Report Post  
Old December 10th 05, 06:21 PM posted to microsoft.public.excel.worksheet.functions
mike b
 
Posts: n/a
Default Macro time out error

The run time error is 1004

application defined or objecr defined error
--
Mike B


"mike b" wrote:

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?

--
Mike B



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help In Excel welshlad Excel Discussion (Misc queries) 14 October 26th 05 02:34 PM
Macro Error...OUT OF MEMORY G118 Excel Discussion (Misc queries) 1 October 15th 05 09:35 PM
Run time error 9 : Subscript out of range JAtz_DA_WAY Excel Discussion (Misc queries) 6 August 29th 05 08:26 PM
Excel 1004 Error When Pasting Special W/ Macro setoFairfax Excel Discussion (Misc queries) 2 April 27th 05 02:28 PM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 7 March 7th 05 07:29 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017