Results 1 to 2 of 2

Thread: Delete row on value of active cell and ac offset

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    populating the next available cell


    dim dRow as double
    dRow = 2
    do until cells(drow,2) = ""
    drow = drow+1
    loop
    cells(drow,2) = dcolumnBValue
    cells(drow,3) = columnCValue


    Deleting the section when the cursor has selected the cell it wants to delete

    range("B"& activecell.row &":C"& activecell.row &"").delete xlup


    Hope that helps!!
    Last edited by NashProjects; 12-23-2011 at 01:57 AM. Reason: Pressed enter too quickly
    Kind regards

    Lee Nash

    http://www.NashProjects.com


Posting Permissions

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