How do I get the last column address

[mecerrato]

I am using the following code to get the last column number but I am trying to get he last column address. So if the last column is 5 then the result I am looking for is "F"

Sub LastColumnInOneRow()
    Dim LastCol As Integer
    With Sheets("Current Pipeline")
        LastCol = .Cells(1, .Columns.Count).End(xlToLeft).Column
    End With
    MsgBox LastCol
End Sub

 

[mecerrato]

No, it is not. Over the years, we have seen many people "carpet bomb" multiple Excel sites with the same question at the same time.
When asked, they usually say that they wanted an answer "as fast as possible".

As we stated, we don't have an issue with it, as long as you follow the guidelines set forth (and note that most other sites have similar rules).
It is really just about having consideration for volunteers time. If a question has already been solved elsewhere, it is helpful to know so as not to waste our time (or even if it is not solved, to not suggest something else that someone has already suggested elsewhere).


Yes, it is spelled out quite clearly in the rules 13 of the rules link we referenced earlier: Message Board Rules

Thanks for your direction, this is 2nd nature to you but I am a novice coder so not as familiar as you are. Thank you for spelling it out so clearly to us novice coders, your services are greatly appreciated

 

[Joe4]

You are welcome.

Going forward, as long as you mention it and includes the links to those other posts, there shouldn't be any issues.