In my code, I am trying to delete a selected set of rows using:
VB Code:
'delete rows If count > 0 Then Rows("1:12").Select Selection.Delete Shift:=xlUp End If
When ran, it carries out the deletion. However when I close excel/quit the application, an excel instance still remains - until I stop the process.
From reading past posts, this is symtom of incorrect code that works (?)...causing an excel instance to hang. The soluiton is to pin-point the code that is causing this. In my case Rows("1:12").Select is the problem.
Is there another way to delete rows in excel?
![]()




Reply With Quote