VBA - user input of row value to use in a cell range

Question

To copy and paste a specific piece of a row to another sheet, I'm attempting to develop a macro. I'm asking the user to enter the row that they want to utilise for copying and pasting.

I want to use a variable that I generated (Dim c) for the user to input the row value in a range, but I'm not sure how.

E.g.

Range("C5:I5").Copy Range("C45:I45")

In the first step of this I want the '5' to be replaced by variable c, but how do I call that variable in this statement?

Tried Range("C(Val(c)):I(Val(c))"), but that hasn't worked.

Apologies for the rookie errors, but I'm fairly new to VBA.

Answer 1

Use this:

Range("C" & c & ":I" & c)