Range("A5", Range("A5").End(xltoRight)).Select

Try that

HTH

Die_Another_Day
CARLOS BAPTISTA wrote:
Please help me. I need to select a range of cells in a row:
For example:from a5 to j5.
I want to have "A5" as "active.cell" and write a macro to select from the
"Active.Cell" to the desired range end.

Is it possible to use "Offset" or other type of commands.

Please if anyone can help.

Kind regards,
--
Carlos