Hello,
I have code similar to the following:

Sub test()
Set Row1 = Range("A15", "AA17")
Set Row2 = Range("A18", "AA20")
Set Row3 = Range("A21", "AA23")
Set Row4 = Range("A24", "AA26")
Set Row5 = Range("A27", "AA29")
Set Row6 = Range("A30", "AA32")
Set Row7 = Range("A33", "AA35")
Set Row8 = Range("A36", "AA38")
Set Row9 = Range("A39", "AA41")

i = 5
Rng = Row&i&
End Sub
What I want to do is create a range (Rng) depending on the value of i (here simply set to 5 for ease of reading). I know what I have written above is incorrect, but I just don't know how to fix it! Any thoughts much appreciated - thanks in advance.