Results 1 to 5 of 5

Thread: [Resolved] Deleting Rows in Excel via Access

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jul 2005
    Location
    Canada
    Posts
    66

    Resolved [Resolved] Deleting Rows in Excel via Access

    In my code, I am trying to delete a selected set of rows using:

    VB Code:
    1. 'delete rows
    2.         If count > 0 Then
    3.             Rows("1:12").Select
    4.             Selection.Delete Shift:=xlUp
    5.         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?

    Last edited by whiteWay; Jul 16th, 2005 at 11:47 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width