Getting error message when trying to sort

T

Trafalgargirl

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi All,

I am trying to sort a simple list and I keep getting the message - The operation requires the merged cells to be equally sized.

I do not remember merging any cells, and I have tried selecting the whole sheet and hitting the merge button, but all that does is merge all of the information into one cell. When I hit merge cells again, it puts back the cells, without all of the information.

Thanks!
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi All,

I am trying to sort a simple list and I keep getting the message - The
operation requires the merged cells to be equally sized.

I do not remember merging any cells, and I have tried selecting the whole
sheet and hitting the merge button, but all that does is merge all of the
information into one cell. When I hit merge cells again, it puts back the
cells, without all of the information.
Click to expand...

Try running this applescript:

tell application "Microsoft Excel"
unmerge used range of active sheet
end tell
 
Top