View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DavidC[_2_] DavidC[_2_] is offline
external usenet poster
 
Posts: 44
Default Variable usage in Range Command

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