Select range in for loop

[always_confused]

Hello, I have a sheet with 35 columns. I would like to create a For loop to go through all the headers of these columns, find a specific one and return the column underneath it as a Range. I have tried

Dim rng As Rang

With Sheets("MySheet"). UsedRange
For i = 1 To .Columns.count
If Cells(1,i).value = "column_name" Then
rng = Column(i)
Next i
End With

But it doesn't seem to want to do Range = Column. I get the error "Object variable or With block variable not set". Is it even possible to set a range to a column? Or is there another way to set up the For loop? My main issue is that ranges are named with letters as far as I understand, but the for loop variable is an integer so I'm trying to use column but maybe there's a better way to do this? I really appreciate any help, thanks

 

[alansidman]

try changing this line of code

rng = Column(i)

to

set rng = Column(i)

 

[always_confused]

try changing this line of code

rng = Column(i)

to

set rng = Column(i)

Used Columns and it worked, thanks a lot