Error UnMerge Selection

[bsquad]

need assistance in the error message I am receiving

Run-time error '13':
Type mismatch


I am trying to un-merge all of the selected cells. This does work aside getting the error.

I am extremely new to VBA programming so its definitely ok to laugh at how simple this one might be.

here is the code I am using

Sub UN_Merge_Ranged()
For Each c In Selection.UnMerge
Next c
End Sub

[jomili]

The command to use is ".MergeCells = False"

Please Login or Register  to view this content.

I think you'd be a bit faster with by just using this line without the For and Next:

Please Login or Register  to view this content.

[bsquad]

Ha, I knew it would be easy, thanks so much.

If you had any suggestions on books for VBA syntax or language and keywords, feel free to suggest


Thanks again

[jomili]

Here's some that will get you started:
https://www.tutorialspoint.com/vba/vba_quick_guide.htm
http://www.excel-spreadsheet.com/vba/vba.htm