range().select function in a macro
 

In a macro, how do you select a range of cells relative to the current
position.
i.e. range(RC,[R+1C+8]).select <=tried this but does not work

Selecting from current row and column position, to the next rox, and next 8
columns.
Thanks

range().select function in a macro
 

ActiveCell.Resize(2,8).Select

--
Charles Chickering

"A good example is twice the value of good advice."


"Peter" wrote:

In a macro, how do you select a range of cells relative to the current
position.
i.e. range(RC,[R+1C+8]).select <=tried this but does not work

Selecting from current row and column position, to the next rox, and next 8
columns.
Thanks