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.
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.