VBA Return Column number of "RTE" in Row 1

[shane_aldrich]

I'm trying to Dim lRTE As Long

RTE is text in row 1, it will appear only once, but can shift column locations

It's the easy ones that throw me.

Thanks,

 

[JLGWhiz]

I'm trying to Dim lRTE As Long

RTE is text in row 1, it will appear only once, but can shift column locations

It's the easy ones that throw me.

Thanks,

Hi Shane, I think you will need to give a better explanation of the problem. If you Dim RTE as Long then you have to give it a numerical value and use it as an integer in your code. From your post, it appears that you are using it on the worksheet and trying to reference it in your code somehow, but I am not sure about that. There is not enough information to really identify the problem.

Maybe you want to use a Find statement like:

Set fCel = Find("RTE", LookIn:=xlValue)
If Not fCel Is Nothing Then
Columns(fCel.Column).Interior.ColorIndex = 15
End If

But you would not Dim RTE, just use it to locat a cell the and then use the variable to make the column reference.