how to start from varible row

  • Thread starter Thread starter Vimal
  • Start date Start date
V

Vimal

Here is an example

p = 1
e = 5
Range(p & "a:b" & e).Select
if p is a variable row and u would want to start a
selection from colum 'a', microsoft will not accept the
above statement, only the 'b" & e' part works.

help, urgently please

thank u
 
Vimal,

Try

Range("A"&p&":B"&e).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Try this

Range("a" & p & ":b" & e).Select

You just had the column and row mixed up for the beginning
of the range.

KB
 
Back
Top