Selecting a range of cells in a macro

V

Victor Delta

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
 
J

JLatham

Here's one way:

Range(ActiveCell.Address & ":" & ActiveCell.Offset(0, 10).Address).Select

Hope that helps.
 
D

Dave Peterson

activecell.resize(1,11).select



Victor said:
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
Click to expand...
 
D

Dave Peterson

But no matter which one is used, the OP should be able to read either to see how
each can be extended to different situations.
 
V

Victor Delta

Dave Peterson said:
But no matter which one is used, the OP should be able to read either to
see how
each can be extended to different situations.
Click to expand...

Very many thanks to you both.

V
 
Top