Specify row with "i" instead of number

[Badgeri]

Hello, i have the following code:

dim i as string
i = 50
args3(0).Value = “$A$2:A50”

basically what i would like is something like
args3(0).Value = “$A$2:Ai”
in other words, instead of haveing A50 i would like Ai (i specifying the end row in this case)

Can anyone help me with this?

[w_whalley]

Try this:

dim i as string
dim args3(0)
i=50
args3(0)="$A$2:A" & i
msgbox args3(0)