Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about ).End(xlToRight) | Excel Programming |