Selecting a range of cells in a macro

  • Thread starter Thread starter Victor Delta
  • Start date Start date
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
 
Here's one way:

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

Hope that helps.
 
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...
 
And Dave Peterson's method is probably faster and more efficient than mine.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Use xldown to select a range of cells 6
After Macro runs, no cell activated - what am I missing? 2
VBA set thick borders around non empty cells in range 0
Macro to insert pictures in comments 8
Excel VBA setting Ranges 2
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
to change the macros as per active cell and range 2

Back
Top