VBA Select range with two variables

Question

I am trying to select range. I have no problem selecting it with variable, lets say x and y are variables. I have no problem writing code to select range from e.g. A1:By. But How do I select a range from Ax:By ? Is there simple one line solution to this?

Thanks in advance for help

My code for A1:By which works

Sheets("Sim").Range("A1:B" & y).Select

My made code from Ax:By which does not work

Sheets("Sim").Range("A" & x ":B" & y).Select

braX · Accepted Answer · 2017-09-27 13:49:04Z

3

You left out an ampersand....

Sheets("Sim").Range("A" & x & ":B" & y).Select

answered Sep 27, 2017 at 13:49

braX

11.9k5 gold badges24 silver badges38 bronze badges

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

3 Comments

Scott Craner Over a year ago

beat me be seconds.

Scott Craner Over a year ago

FWIW; @JiříJezdinský one should avoid using .Select and just do the action wanted. ie Sheets("Sim").Range("A" & x & ":B" & y).Copy

Jiří Jezdinský Over a year ago

Thanks for the solution (I just totally forgot about another &). And also thanks for the select notice.

Collectives™ on Stack Overflow

VBA Select range with two variables

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related