Refer to last non-empty cell in a row

[Hermac]

Hello,
I'm looking for the fastest VBA reference for the range [H1:X1], whith [X1] being the varying bat furthest non-empty cell to the right of row 1.
I know it's a rather banal question but I can't get it done.
Can anyone give me a hand.
Thanks a lot!
Herman

 

[DanteAmor]

I don't understand what you need, could you explain it with examples.

 

[MARK858]

If the cells to the right of X1 are truly empty then maybe try...

Range("H1", Cells(1, Columns.Count).End(xlToLeft)).Select

The .Select is just for demo purposes

 

[Hermac]

Thank you very much, Mark.

 

[MARK858]

You're welcome