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...