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!

Michael,

Try

Rows("2:" & MyVar).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Michael Smith" wrote in message
...
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!