Hi Rachit,

range(a & ":l30").Select

--
Kind regards,

Niek Otten

wrote in message oups.com...
|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
|