+ Reply to Thread
Results 1 to 10 of 10

Need to delete Duplicate active cell in ROW (ROOM or Subject)

Hybrid View

  1. #1
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,293

    Re: Need to delete Duplicate active cell in ROW (ROOM or Subject)

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Cells.Count > 1 Then Exit Sub
        If Target.Value = "" Then Exit Sub
        If Intersect(Target, Range("E:E, G:G, I:I , K:K, M:M, O:O, Q:Q, S:S")) Is Nothing Then Exit Sub
    
        If Application.CountIf(Target.EntireRow, Target.Value) > 1 Then
            Application.EnableEvents = False
            Application.Undo
            MsgBox "Don't duplicate values in a row!"
            Application.EnableEvents = True
        End If
    End Sub
    Bernie Deitrick
    Excel MVP 2000-2010

  2. #2
    Registered User
    Join Date
    02-06-2022
    Location
    Sri lanka
    MS-Off Ver
    365
    Posts
    6

    Re: Need to delete Duplicate active cell in ROW (ROOM or Subject)

    Dear Bernie,
    Thanks lot for all support, it working well.

    Best regard
    Indika

+ 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. [SOLVED] If date matches and room matches, return room info in to cell
    By HonorBray in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-12-2018, 12:09 PM
  2. [SOLVED] How to Calculate Hotel room nights booked, for each night, and broken down by room type?
    By salsadantzr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-09-2018, 04:53 PM
  3. [SOLVED] Help comparing two files by subject+Date, subject+DatePlus1, Subject+DateMinus1
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-11-2017, 07:37 AM
  4. Room Allotment:remove allotted room from dropdown list
    By amdrosm in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-05-2017, 04:50 AM
  5. Duplicate message alert with room booking form and calendar
    By chillz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2017, 07:37 AM
  6. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  7. Replies: 1
    Last Post: 05-11-2011, 07:11 AM

Tags for this Thread

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