Merged cells
I am having one of those problems with copying from one sheet and edit paste special values to another sheet. It says merged cells are not identically sized. So, I am trying to find and clear all merged cells, though I want to know which they are.
Can someone tell me how to identify which cells are merged? I tried deleting rows and columns but they seem to be in multiple places, so this method is not working well. Thanks! Dean |
Merged cells
Dean
CTRL + a(twice in 2003) to select all cells. FormatCellsAlignment. Uncheck "merged cells" Gord Dibben MS Excel MVP On Tue, 12 Sep 2006 16:11:55 -0700, "Dean" wrote: I am having one of those problems with copying from one sheet and edit paste special values to another sheet. It says merged cells are not identically sized. So, I am trying to find and clear all merged cells, though I want to know which they are. Can someone tell me how to identify which cells are merged? I tried deleting rows and columns but they seem to be in multiple places, so this method is not working well. Thanks! Dean |
Merged cells
Sub AA()
Dim cell As Range For Each cell In ActiveSheet.UsedRange If cell.MergeArea.Count 1 Then If cell.Address = cell.MergeArea(1).Address Then MsgBox cell.Address & " area: " & cell.MergeArea.Address End If End If Next End Sub -- Regards, Tom Ogilvy "Dean" wrote in message ... I am having one of those problems with copying from one sheet and edit paste special values to another sheet. It says merged cells are not identically sized. So, I am trying to find and clear all merged cells, though I want to know which they are. Can someone tell me how to identify which cells are merged? I tried deleting rows and columns but they seem to be in multiple places, so this method is not working well. Thanks! Dean |
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com