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?!

Selection of variable rows
 

something like this do you?

Dim N As Long
N = 11
Rows("3:" & N).Select

Selection of variable rows
 

something like this do you?

Dim N As Long
N = 11
Rows("1:" & N).Select

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?!

Selection of variable rows
 

Great Thanks

" wrote:

something like this do you?

Dim N As Long
N = 11
Rows("3:" & N).Select

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?!