Hi Batty,

I'm a bit confused by 'half a column' but if you mean you want to select
your used range only and leave blank cell then something like this may help:-

Sub ranges()
Dim myrange As Range
rowno = ActiveSheet.Range("A65536").End(xlUp).Row
Set myrange = Range("A1:K" & rowno) '< Alter A1 and K to suit
myrange.Select
End Sub

Mike

"Battykoda" wrote:

Good Morning to you all.

Little question here today. I got a worksheet that the lenght can change for
month to month. All i need is to select only half the column in a macro. So
far i found how to make my macro select all of them, and it's no good.

Any suggestion?


Batty