Results 1 to 8 of 8

Vba code at least keep 2 rows

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    921

    Vba code at least keep 2 rows

    Hello

    This is TABLE1


    as seen now table1 has 10 rows,is there any code I put it in worksheet change sub or anywhere, that keep at least two rows inside the table if user/macro try to delete rows ?
    i dont want to lock 2 rows, because when locked i got errors from macros, i just need the code to keep at least 2 rows

    Thanks

    key = 1
    Attached Files Attached Files
    Last edited by Undo; 07-30-2019 at 09:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy rows out of a datasheet based on a code number and past these rows in a new sheet
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2018, 11:41 AM
  2. [SOLVED] Need VBA code to lookup vaue through micr code copy matching rows to under group
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2016, 12:25 AM
  3. need vba code to split rows to closed wb shets depends company code met with sht name
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 12:44 PM
  4. [help with code] need to update existing code to copy and keep rows on input page
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2016, 01:36 PM
  5. Need VBA Code to Ignore Hidden Rows Page Break (Rows Grouped/Ungrouped)
    By Photosweet2006 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2015, 11:48 AM
  6. Replies: 9
    Last Post: 05-24-2013, 01:31 PM
  7. Code to delete rows based on status code in Column I
    By LemonTwist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2009, 07:01 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