Specify row with "i" instead of number [closed]

asked 2013-03-04 12:16:13 +0100

Badgeri
1 ●2 ●1

updated 2020-07-13 16:39:59 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 04:02:01.049638

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2013-03-04 15:18:35 +0100

w_whalley

3837 ●6 ●22 ●45

Try this:

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

edit flag offensive delete link

add a comment

Question Tools

Stats

Asked: 2013-03-04 12:16:13 +0100

Seen: 38 times

Last updated: Mar 04 '13

Specify row with "i" instead of number [closed] edit

Closed for the following reason question is not relevant or outdated by Alex Kemp close date 2015-10-26 04:02:01.049638

1 Answer

Question Tools

Stats

Related questions

Specify row with "i" instead of number [closed]

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 04:02:01.049638