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


---
Message posted from http://www.ExcelForum.com/