Selection code

S

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
 
B

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)
 
T

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
 
Top