VBA to merge cells automatically when text is typed into cell.

[Matthew2]

Managed to get a solution. Solved

I am trying to as you type into certain cells it merges with the next cell next to it.
Therefore If E1 contains Kayaking or SUP or Canoeing or (keep going etc for a several more) it merges E1 to E2.
These ranges would be in several rows down in several columns.
If specific text found in a row in column E, merge with column F
If specific text found in a row in column I, merge with column J
If specific text found in row in column M, merge with column N etc

I have written a macro that does this, however would like to do it when you type into a cell so it shows. I know merging cells keeps the left most information, the cell to right would be blank anyway.
I found an old post, cannot remember where now that had a similar problem, but this merges only when you click left and not enter is pressed and I am struggling to adapt it. The code is below.
For Each rw In Selection.Rows
If Cells(rw.Row, 1) = 5 Then 'column A of each row
Range(Cells(rw.Row, 3), Cells(rw.Row, 6)).Merge
End If
Next rw
End Sub

[AliGW]

Administrative Note:

Please share the solution you found for the benefit of all.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)