Or, if you just want to remove, try Sub unmergecells() Cells.MergeCells = False End Sub From: NOORAIN ANSARI Sent: Thursday, September 15, 2011 6:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Finding Merged cells in excel
Dear Amit, Please try it............. Sub findmerged_cell() Dim str As String Dim stri As String For Each c In Selection If c.MergeCells Then str = c.Address stri = stri & "," & str End If Next stri = "(" & Mid(stri, 2, 1000) & ")" Range(stri).Select End Sub Thanks & regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Sep 15, 2011 at 1:15 PM, Amit Gandhi <silkyro...@gmail.com> wrote: Hi Folks I am finding some problem in excel data. Pls help me here. I have a excel data in 10 columns and 20000 rows. There are some MERGED CELLS in this data. I am applying filters and its not working due to merged data. Is there any way in Excel to find merged cells automatically. Pls help me here. Regards Amit -- -- Thanks & regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel