Select used range just in one column

[freshtomm]

Hi guys,

i wanted to ask whether is it possible to select used range just in one specific column? I am alerady using code below to select whole used range, but i need to do that just in one column.

 ActiveSheet.UsedRange.Copy

Thanks.

 

[Marc L]

Hi !

Just respecting TBTO rule : ActiveSheet.UsedRange.Columns(1).Copy …​

 

[freshtomm]

I see, thank you.