Loop-help for a newbie?

[pcsailor]

Wow, awesome Perfringo. Thanks.
I was going a different direction by creating a dictionary and working on the letters to swap. Wasn't working out so well. This is so humbling!

merge_cells = {
    'B10' : 'B10:C10', 'D10' : 'D10:E10', 'F10' : 'F10:G10', 'H10' : 'H10:I10'
    }
print (merge_cells)

def merge(x,y):
    for i in merge_cells:
        sheet.merge_cells('i')

Phil

---

If you have only 4 pairs then zip is probably overkill, you can write it manually:

cols = [('B', 'C'), ('D', 'E'), ('F', 'G'), ('H', 'I')]

I'm not sure what you mean here by 'zip'. This is a pretty big SS though and I put a very small snippet in this post.
Phil