Selection code
 

What would be the proper format for writing a macro to select a certai
range of rows (like 6:6 to 206:206)?
It keeps giving me the -Method 'Range' of object '_Global' failed-
error.
Thanks

--
Message posted from http://www.ExcelForum.com

Selection code
 

Try something like the following;

Range("6:206").Select




"sixfivebeastman "
wrote in message
...
What would be the proper format for writing a macro to select a
certain
range of rows (like 6:6 to 206:206)?
It keeps giving me the -Method 'Range' of object '_Global'
failed-
error.
Thanks!


---
Message posted from http://www.ExcelForum.com/

Selection code
 

Rows("6:206").Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"sixfivebeastman " wrote in
message ...
What would be the proper format for writing a macro to select a certain
range of rows (like 6:6 to 206:206)?
It keeps giving me the -Method 'Range' of object '_Global' failed-
error.
Thanks!


---
Message posted from http://www.ExcelForum.com/

Selection code
 

Here is one mo

rows(6).Resize(201).Select

and another
Range("A6:A206").EntireRow.Select

and another:
Range(rows(6),rows(206)).Select

--
Regards,
Tom Ogilvy

"sixfivebeastman " wrote in
message ...
What would be the proper format for writing a macro to select a certain
range of rows (like 6:6 to 206:206)?
It keeps giving me the -Method 'Range' of object '_Global' failed-
error.
Thanks!


---
Message posted from http://www.ExcelForum.com/