I am writing a Macro in Microsoft Excel.

I know that to select e.g. row 5, I would code:

rows("5:5").select.

However, if I use a variable to move about the worksheet i.e. Range("A" & targetrow).Select (where targetrow is a variable), I can't hard-code the row selection as above.

Is there syntax to use a variable in the rows().select statement, or is there anyway of selecting 'the current row'?