Solved: Resize to last cell and select

[u25103]

Hi
I want to resize the selected cell to the last cell, that has a value within and select the hole area.

I've tried with selection.resize(1, Selection.End(xlToRight)).Select

but it didn't work

I hope that there someone out there that has a god idea to solve this one.

Thanks:think:

[mdmackillop]

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

[u25103]

Thank you

""Sometime you don't see the forest because all the trees are in line of sight"":bow: