View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 1
Default how to start from varible row

Try this

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

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

KB

-----Original Message-----
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
.