VBA code to select next empty cell in column + actions

[DragonPlush]

So I'm struggling to figure out how to get my VBA macro to work. Basically I need to find a select the next empty cell after U5, Clear the contents of that cell plus the next two columns (V & W) and then merge all three cells in the row.

I've tried using relative references and recording a macro but it has en error every time I try to use it.

Anyone got an idea?

 

[DragonPlush]

What I've got so far is:

Range.("U7").End(xldown.offset(1,0).select
Selection.clearcontents

But can't get the next two cells in the row and merge them part to work so I just deleted my attempt for now

 

[Joe4]

Welcome to the Board!

Try this:

    With Range("U5").End(xlDown).Offset(1, 0).Resize(1, 3)
        .ClearContents
        .Merge
        .Select
    End With