(xlToRight)

  • Thread starter Thread starter dallas
  • Start date Start date
D

dallas

Hi


- - - - - - -
Range(ActiveCell, ActiveCell.End(xlToRight)).Select
- - - - - - -

I want to change .....

Range(ActiveCell, ##############(xlToRight)).Select

############## = "6 columns"

Example: If ActiveCell is "C10"
then i want "C10:H10" to be Select


Dallas
 
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

Inserting 2 columns when cells don't match 6
Perplexing IF statement 4
Help Simplifing Code 3
Can Vba workout if a selection is part of a group? 0
How to use the worksheetfunction Vlookup 7
excel macro missing worksheets 9
Using a range object inside a formula 3
Insert columns and values programmatically with IF statement 9

Back
Top