xlToRight Command

[mikeymay]

I am wanting to select a range of cells in a row that has
a couple of empty cells at various places within the
range. I have used -

Range(Activecell, Activecell.End(xlToRight)).Select

to select the cells before the first empty cell in the
range, but how do I select the whole range?

Can't take out the columns with empty cells as sometimes
there will be data in these cells and other times not.

Many thanks in advance.......

 

[Ron de Bruin]

Try this

Range(ActiveCell, Cells(ActiveCell.row, Columns.Count).End(xlToLeft)).Select