Variable Value within Range

Question

Hello,

I am trying to create a dynamic range by adding value of variable within range but it doesn't work.

Dim LastRow as Long
LastRow = Sheet2.Range("F1"). Current.Rows.Count + 1

........
Range("F&"+LastRow+"").Select
........

Do I add variable correctly to the range?

I'd really appreciate if someone reviews the screenshots and helps me to understand what I am doing wrong. I need to add the same variable value to the "Data!R1C1:R1000C2" range instead of static"1000"

Many thanks in advance.

Regards.

Answer 1

Try this: Range("F" & LastRowDuplicates).Select.

And this: "Data!R1C1:R" & someVariable & "C2".