VBA How to choose the range of the selected line to the last cell with the value to the right

[Palucci]

I have a macro that chooses me the result from the INPUT Box, however, I would like instead of selecting all from the range (ROW 109 )to the right to the last column with values. Like a below screen

Dim loc As Range
With data_wb.Sheets("Final")
    Set loc = .Cells.Find(what:="inputbx")
    If Not loc Is Nothing Then
        .Cells(109, loc.Column).Resize(15).Copy
    End If
End With

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA Excel Macro find column name and next need to copy range [SOLVED]
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Palucci]

How to remove this post?

 

[Fluff]

How about

        .Range(.Cells(109, loc.Column), .Cells(109, Columns.Count).End(xlToLeft)).Copy