Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Excel macro that runs fine on many people's computers, but on one
person's machine the delete line (set off with asterisks below) takes forever; when she gets to it, everything in the Task Manager related to Microsoft Office (not just Excel) shows the ol' "Not Responding" message. She has waited as long as 45 minutes before giving up on a process that takes only a few seconds on other machines. Any ideas? Sub DynamicGet(intField As Integer, strCriterion As String) Columns("AA:AD").Select Selection.AutoFilter Field:=intField, Criteria1:=strCriterion Range("A2:BD30000").Select **********Selection.EntireRow.Delete************ Selection.AutoFilter Field:=intField Range("A2").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel macro in 2007 runs extremely slow | Excel Discussion (Misc queries) | |||
Extremely slow macro | Excel Programming | |||
macro running extremely slow | Excel Programming | |||
Macro that deletes certain rows only | Excel Programming | |||
Macro that deletes certain rows and not others | Excel Programming |