View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack77 Jack77 is offline
external usenet poster
 
Posts: 1
Default 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.