title: Merged Cells Messing Up VBA Code Regarding Cell Selection
body: <p>I have the basic problem (which had already been answered a hundred times) on how to allow the user to only select a single cell at a time (prevent multiple cells being active). If the user tried, it would redirect the active selection to a specific cell (B1). Based on a quick google search, intelligent copy and pasting, and some slight edits, this is what I end up with:</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  
       '&gt;&gt; Prevent user from multiple selections
  
      If Selection.Cells.Count &gt; 1 Then
          MsgBox "Multiple Selection Disabled, refer to B1"
          ActiveSheet.Range("B1").Select
          Exit Sub
      End If
  
  End Sub
  </code></pre>
  
  <p>A simple code. However, the problem I run into is that whenever I select a merged cell, the code triggers since the selection is, according to excel, more than one cell. How do I go around this? Thanks.</p>
  
  <p>I've inherited this file from another person, so there was already a lot of merged cells. And my worksheet is highly automatized and VBA rich. Asking me to remove all merged cells is (practically) not an option.</p>