David,

Range("B1:B" & test)

hth,

Doug Glancy

"DavidC" wrote in message
...
Help please

When using the Range("B1:B50").Select I want to
substitute a variable into the Range.

I have a variable which is a number e.g test=50

Therefore the command I want is
Range(B1:B'test'").Select

I cannot get the syntax right.

Idea is to select a range of data based on variables.
Is this the right way?

Cheers
David