A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't Sort Worksheet - Merged Cells Must be Identically Sized



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2004, 02:38 AM
external usenet poster
 
Posts: n/a
Default Can't Sort Worksheet - Merged Cells Must be Identically Sized

A user has an Excel 2002 workbook that she needs to be
able to sort by a particular column. When she tries to
sort, she gets the message: "This operation requires the
merged cells to be identically sized." I don't see any
merged cells when I examine the worksheet. It doesn't
matter which column you try to sort by, you still get the
same error. I found MS KB article 291063, but the
solution that it provides (unmerge cells) doesn't help,
because there are no merged cells that I can find.
Looking for any help on this. Thanks.
  #2  
Old February 4th, 2004, 03:18 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default Can't Sort Worksheet - Merged Cells Must be Identically Sized

Do a ctrl-A (to select all the cells on the worksheet)
Format|cells|alignment tab.

Look at the Merge cells box.
If it's got a grey check in there, you have merged cells somewhere in that
selection!

You can get rid of all of the merged cells by just unchecking that box. (But
you may screw up the formatting--so be careful.)

You could search the usedrange for merged cells (divide in half and look at that
format|Cells|alignment tab). Then divide each piece in half until you find it
(them???).

Or you could run a macro to help:

Option Explicit
Sub testme02()

Dim myCell As Range
Dim resp As Long

For Each myCell In ActiveSheet.UsedRange
If myCell.MergeCells = True Then
If myCell.Address = myCell.MergeArea.Cells(1, 1).Address Then
resp = MsgBox(Prompt:="found at: " _
& myCell.Address(0, 0) & " Of " _
& myCell.MergeArea.Address(0, 0), _
Title:="Continue Looking?", _
Buttons:=vbYesNo)
If resp = vbNo Then
Exit Sub
End If
End If
End If
Next myCell

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

wrote:

A user has an Excel 2002 workbook that she needs to be
able to sort by a particular column. When she tries to
sort, she gets the message: "This operation requires the
merged cells to be identically sized." I don't see any
merged cells when I examine the worksheet. It doesn't
matter which column you try to sort by, you still get the
same error. I found MS KB article 291063, but the
solution that it provides (unmerge cells) doesn't help,
because there are no merged cells that I can find.
Looking for any help on this. Thanks.


--

Dave Peterson

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.