Put String argument in Range - VBA

Question

I have a little problem in VBA, I want to put row and column of Range function in String format like that :

    debut = "BH" & LTrim(Str(i))
    fin = "DB" & LTrim(Str(i))
    For Each Cell In Ws.Range("debut:fin")

But i have an error, how can i resolve it ? Thanks

assylias · Accepted Answer · 2012-05-27 14:54:42Z

3

The way you have done it ("debut:fin"), the range is really equal to that string and is invalid. What you need to do is concatenate the 2 strings with a : in between with the & operator:

For Each Cell In Ws.Range(debut & ":" & fin)

answered May 27, 2012 at 14:54

assylias

330k84 gold badges680 silver badges806 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Siddharth Rout Over a year ago

+ 1 :) Also "BH" & LTrim(Str(i)) can also be written as "BH" & i

Collectives™ on Stack Overflow

Put String argument in Range - VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related