| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select whole rows desired by user | Excel Programming | |||
| Use find to select entire rows with a cell with that value | Excel Worksheet Functions | |||
| select entire rows using a contains comparison - an example | Excel Programming | |||
| Draw a circle to select a desired collection | Excel Programming | |||
| Draw a circle to select a desired collection | Excel Programming | |||
Hybrid Mode
