| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"rows" syntax
I would like to select a range of rows as follows:
Rows(a,b).Select Can anybody help me with the correct syntax? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"rows" syntax
Hi
one way: Range(Rows(a),rows(b)).select -- Regards Frank Kabel Frankfurt, Germany Claude wrote: I would like to select a range of rows as follows: Rows(a,b).Select Can anybody help me with the correct syntax? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"rows" syntax
Thanks Frank, this is what I was looking for...
-----Original Message----- Hi one way: Range(Rows(a),rows(b)).select -- Regards Frank Kabel Frankfurt, Germany Claude wrote: I would like to select a range of rows as follows: Rows(a,b).Select Can anybody help me with the correct syntax? Thanks! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"rows" syntax
The following selects rows 1 and 2:
Sub Row_Select() Rows("1:2").Select End Sub -- Michael J. Malinsky "Claude" wrote in message ... I would like to select a range of rows as follows: Rows(a,b).Select Can anybody help me with the correct syntax? Thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"rows" syntax
Hi Claude,
rows("1:5").select if a and b are variables then rows(a & ":" & b).Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Claude" wrote in message ... I would like to select a range of rows as follows: Rows(a,b).Select Can anybody help me with the correct syntax? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| syntax for "IF" commend to check for multiple empty cells bf comma | Excel Worksheet Functions | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| what is syntax for if(between range of dates,"Q1","Q2")? | Excel Worksheet Functions | |||
Hybrid Mode
