Range based on two variables

**kinseld5** · 09-20-2012, 12:07 PM

Hi,

I can do a range based on one variable, as below:

But what if I want the number 4 below to be the variable, x, how do I code this? Thanks.

Please Login or Register  to view this content.

**DBY** · 09-20-2012, 12:19 PM

Hello
Try amending your code to the following:

Please Login or Register  to view this content.

This selects the range B2:B8.

Hope this helps.
DBY

**HaHoBe** · 09-20-2012, 12:19 PM

Hi, kinseld5,

either

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Ciao,
Holger

Re: Range based on two variables