Selection code

[sixfivebeastman]

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

 

[Chip Pearson]

Try something like the following;

Range("6:206").Select




"sixfivebeastman >"

 

[Bob Phillips]

Rows("6:206").Select

--

HTH

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

 

[Tom Ogilvy]

Here is one more:

rows(6).Resize(201).Select

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

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