Macro to Merge Cells In a Row Based on Value

[JHCali]

Hi Folks,

I have a spreadsheet with the following range: I13:AM307

Within this range, some rows have cells that contain "x" within (not over) colmuns I:AM. Other rows have no "x" over columns I:AM.

What I need a macro to do is to cycle through this range, and for each individual row, merge the cells that contain "x". These cells containing "x" are contiguous in a given row.

Thank you very much in advance.