| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection of variable rows
I need to select a range of rows in some data which can be variable.
How do you write in a macro to select say rows 1 to N, where the N is dependent on other factors in the macro. possible sublimely simple?! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection of variable rows
something like this do you?
Dim N As Long N = 11 Rows("3:" & N).Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection of variable rows
something like this do you?
Dim N As Long N = 11 Rows("1:" & N).Select |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection of variable rows
How do you write in a macro to select say rows 1 to N ?
Sub Demo() Dim n As Long n = 5 Rows(1).Resize(n).Select End Sub -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Archie" wrote in message ... I need to select a range of rows in some data which can be variable. How do you write in a macro to select say rows 1 to N, where the N is dependent on other factors in the macro. possible sublimely simple?! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection of variable rows
Great Thanks
" wrote: something like this do you? Dim N As Long N = 11 Rows("3:" & N).Select |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection of variable rows
great thanks
"Dana DeLouis" wrote: How do you write in a macro to select say rows 1 to N ? Sub Demo() Dim n As Long n = 5 Rows(1).Resize(n).Select End Sub -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Archie" wrote in message ... I need to select a range of rows in some data which can be variable. How do you write in a macro to select say rows 1 to N, where the N is dependent on other factors in the macro. possible sublimely simple?! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a variable selection size ? | Excel Programming | |||
| How do I include an all tab in a pivot variable selection | Excel Discussion (Misc queries) | |||
| Object Type of a selection... counting rows in a selection | Excel Programming | |||
| Variable for column selection | Excel Programming | |||
| Assign a variable from a Listbox selection. | Excel Programming | |||
Linear Mode
