how to select entire rows desired by user
 

How can we select entire rows as desired by user i.e. the user gave the
parameters, we put them in our syntax such as rows(a,b).select. But this way
it is not working. User's input are a & b. So how to make it work?
--
Anupam Soral

how to select entire rows desired by user
 

Rows(a).Resize(b).Select

--
__________________________________
HTH

Bob

"Anupam Soral" wrote in message
...
How can we select entire rows as desired by user i.e. the user gave the
parameters, we put them in our syntax such as rows(a,b).select. But this
way
it is not working. User's input are a & b. So how to make it work?
--
Anupam Soral

how to select entire rows desired by user
 

Rows("1:5").Select

or

Rows(a & ":" & b).Select


"Anupam Soral" wrote:

How can we select entire rows as desired by user i.e. the user gave the
parameters, we put them in our syntax such as rows(a,b).select. But this way
it is not working. User's input are a & b. So how to make it work?
--
Anupam Soral

how to select entire rows desired by user
 

Thanks a lot Joe. Improvement in the syntax provided by u really resolved by
problem.
--
Anupam Soral


"Joel" wrote:

Rows("1:5").Select

or

Rows(a & ":" & b).Select


"Anupam Soral" wrote:

How can we select entire rows as desired by user i.e. the user gave the
parameters, we put them in our syntax such as rows(a,b).select. But this way
it is not working. User's input are a & b. So how to make it work?
--
Anupam Soral