Dumb Dim Question

  • Thread starter Thread starter Michael Smith
  • Start date Start date
M

Michael Smith

I have what is probably a simple dim question....

I have set a variable....
Dim MyVar
MyVar = Range("AG1").Text

Now I want to select a range of rows from the 2nd row to the row# that
is my variable. (EX.(If MyVar is 10, then I want to select rows 2 thru
10)

I tried..
Rows("2:MyVar").Select
and it obviously failed with a type mismatch.

Thanks in advance!
-Mike

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Back
Top