try
range("g6").select ' You DONT need to do this. Just use

cells(6,columns.count).end(xltoleft).select

however, it is almost never necessary or desirable to SELECT.

--
Don Guillett
SalesAid Software

"geebee" wrote in message
...
hi,

I have the following:

Range("G6").Select
Range(Selection, Selection.End(xlToRight)).Select

The opnly problem is that G6 is empty, so when the command executes, it
goes
to the very next cell to the right, instead of the true last cell to the
last
where data has been entered.

How can I get it to go to the last cell to the right where data has been
entered?

Thanks in advance,
geebee