Consulting

Results 1 to 3 of 3

Thread: Solved: delete a row

  1. 11-09-2007, 07:02 AM #1
    ProteanBeing
    ProteanBeing is offline
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location

    Solved: delete a row

    How do I delete a hole row in excel VBA?
    Reply With Quote Reply With Quote
  2. 11-09-2007, 07:28 AM #2
    ProteanBeing
    ProteanBeing is offline
    VBAX Tutor
    Joined
    Oct 2007
    Posts
    210
    Location
    nevermind, I figured it out.

    worksheets(index).cells(row, col).EntireRow.delete
    Reply With Quote Reply With Quote
  3. 11-09-2007, 07:54 AM #3
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Simpler

    [vba]

    Worksheets(index).Rows(row).Delete
    [/vba][
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules