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