View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default calling variable within string

i am a novice in VBA programming. I am looking to call a variable
within a string.

for example

a = "E13" (Cell reference)
Range("a: L30").select (Giving me error because variable a cannot
be called in within the Range)

I intend to select cells in the range E 13 to L 30. Any way to make
this work? Basically the starting cell of this range is dynamic and I
want to select that range.

Thanks,
Rachit