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
But you would not Dim RTE, just use it to locat a cell the and then use the variable to make the column reference.