(xlToRight)

[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

 

[Tom Ogilvy]

ActiveCell.Resize(1,6).Select