+ Reply to Thread
Results 1 to 4 of 4

Delete rows shift data from userform

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Delete rows shift data from userform

    How do I change this code to delete and shift the entire row when a user selects a range attribute? Right now the original code only works for only A. I need the selected row deleted and proceeding data shifted up. This is what I have so far:
    Please Login or Register  to view this content.
    Last edited by terriertrip; 06-28-2017 at 04:35 PM.

  2. #2
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Re: Delete rows shift data from userform

    Is there no one that can give me a little guidance on this?

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Delete rows shift data from userform

    Perhaps.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Re: Delete rows shift data from userform

    Thanks, Norie. I had a few codes going but this seems to work pretty good.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Edit/Delete data rows using VBA / Userform
    By BigPaulMc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2015, 05:17 PM
  2. How to find the blank rows and then delete them/shift them up
    By travis.cook21 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-13-2015, 11:52 AM
  3. [SOLVED] Loop to Delete Rows and Shift Up on Cell Value
    By ayvee0 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2013, 11:04 AM
  4. [SOLVED] compare two columns, delete non matches in partial rows using shift up
    By acp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2013, 09:39 AM
  5. [SOLVED] Delete blank rows between data rows, shift rows up, then repeat
    By excelactuary in forum Excel General
    Replies: 2
    Last Post: 03-11-2013, 11:53 AM
  6. Delete Range of Rows and Columns and Shift Up
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2012, 02:02 PM
  7. [SOLVED] Locking a couple rows so when you do a delete shift row they dont
    By palukagoat in forum Excel General
    Replies: 3
    Last Post: 03-22-2005, 02:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1