And Dave Peterson's method is probably faster and more efficient than mine.

"Dave Peterson" wrote:

activecell.resize(1,11).select



Victor Delta wrote:

Can anyone help me with this please.

I have written an Excel (XP) macro that has to start by selecting a range
based on the active cell and the 10 cells to its right.

How do I put this into VBA code please?

Thanks,

V

--

Dave Peterson