Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable to select rows
What is wrong with this macro? I'm trying to use variable to select rows but
when I execute it I get type mismatch error. Sub Test() Dim start As String Dim end As String start = 1 end = 2 Rows("start:end").Select End Sub In this case it should select rows 1 and 2. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable to select rows
Sub Test()
Dim sStart As String Dim sEnd As String sStart = 1 sEnd = 2 Rows(sStart & ":" & sEnd).Select End Sub Regards Trevor "Jack77" wrote in message ... What is wrong with this macro? I'm trying to use variable to select rows but when I execute it I get type mismatch error. Sub Test() Dim start As String Dim end As String start = 1 end = 2 Rows("start:end").Select End Sub In this case it should select rows 1 and 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a Range Through a Variable | Excel Programming | |||
Select Sheet - Variable | Excel Programming | |||
worksheet select using variable | Excel Programming | |||
Select rows using a variable | Excel Programming | |||
select last 3 rows of variable length coloumn in excel 2003? | Excel Programming |