VBA to Merge Cells based on Other Column Values

Hi - first post to this forum. Now I know that merging cells is usually not a good thing in VBA, but I'm working on a data report that just looks bad unless longer pieces of text can span several cells to minimize column width.

So here's the problem:

I have a column of 1's and 0's in columns E and F, and text in Column G. I want to merge the cells in columns G and H for that specific row if there is a 1 in either the E or F column for that specific row. And I need to do this for a long range...rows 7-5000. Any ways that VBA can do this?

Thanks for the help.

Solus - thanks for the help - but it looks like this is just centering the text in the cell and not across multiple cells. The text is large, but only for a few rows here and there, and I don't want to increase the whole width of the column just for these texts. Does centering across a range act similar to merging?

I combined your code with something else and got it to work. Thanks for the help!