WindsorKnot
Board Regular
- Joined
- Jan 4, 2009
- Messages
- 160
Hi,
Does anyone know how to write vba to check if there are any merged cells in the worksheet, and if so to unmerge them?
Thanks.
I think this may work below
Does anyone know how to write vba to check if there are any merged cells in the worksheet, and if so to unmerge them?
Thanks.
I think this may work below
Code:
Sub test()
Range("a1:IV65536").Select
Selection.UnMerge
Range("E9").Select
End Sub
Last edited: