ExcelBanter - (xlToRight)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - (xlToRight) (https://www.excelbanter.com/excel-programming/308959-xltoright.html)

dallas

(xlToRight)

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/

Tom Ogilvy

(xlToRight)

ActiveCell.Resize(1,6).Select

--
Regards,
Tom Ogilvy

"dallas " wrote in message
...
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/

All times are GMT +1. The time now is 06:52 PM.