Results 1 to 5 of 5

Merge cells with same number within specific column range.

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    Wink Merge cells with same number within specific column range.

    Hi Wizards,

    Please can you help I am using this formula but I need the cells that have the same value between E17 and E758 merged not the whole column.

    Sub mergethem()
    Dim x As Long
    Application.DisplayAlerts = False
    For x = Range("E" & Rows.Count).End(xlUp).Row To 1 Step -1
    If Range("E" & x) = Range("E" & x - 1) Then Range("E" & x - 1).Resize(2).Merge
    Next x
    Application.DisplayAlerts = True
    End Sub
    Thank so much..
    Last edited by Leith Ross; 03-09-2016 at 01:46 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum specific number of cells in one column
    By Blue_Wings in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2015, 09:46 AM
  2. Assigning x number of random cells in a range a specific value
    By DGtil in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2014, 06:52 AM
  3. Check for Number in one column - then count specific numbers in a range.
    By CarlosM1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-29-2014, 05:10 AM
  4. [SOLVED] VBA: Select Range of Cells in one Column, Merge, and then proceed to Next Column
    By magasi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2013, 12:17 PM
  5. [SOLVED] Find specific cell and return column number from a dynamic range
    By nivoe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2012, 12:39 PM
  6. [SOLVED] how to select a range and then add a specific number of cells after it
    By dwassner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2012, 08:41 AM
  7. Sum of 2 cells in a column equal a specific number
    By philippe1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-14-2011, 01:43 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