Assistance setting up a "last row" macro

[londa_vba]

Hello
I found a formula that correctly identifies my last row with value results. I used the record macro feature to convert it to vba code. Now I need help piecing it together.
I am trying to identify the last row with value results and then add the text "AL" to the cell directly beneath it.

the formula that worked for me is =LOOKUP(2,1/((C:C)<>""),ROW(C:C))
when converted to vba, I got

Formula2R1C1 = "=LOOKUP(2,1/((C[-3])<>""""),ROW(C[-3]))"

That's as far as I have been able to take myself...

 

[Joe4]

If I needed to take this code one step further and have the value = to "AL" PLUS the value in the cell two columns to the left (column A) of whatever that last row is. How would I achieve that?

I don't understand what you are asking.
Please show me an example of your data and exactly what you are trying to do.

 

[londa_vba]

I don't understand what you are asking.
Please show me an example of your data and exactly what you are trying to do.

I had to change the data in order to share with you. I changed "AL" to "Ladder" since are first conversation.
Short story: I need to put "Ladder_" + value of cell A4 which is "C6" in the screen shot example. See yellow cells for reference

Long story: Ladders automatically go in odd A cells such as A1, A3, A5 etc for every list imported.
However there has to be a minimum of two Ladders per list so for small lists the first ladder still goes in an odd A cell but the second will just go at the end of the list. Hence why I originally asked for vba help. But I need to identify each ladder by referencing the value in column A which will vary according to the length of the list but will always be the value in column A of whatever the last row is.

I'm sure that was clear as mud

 

[Joe4]

I'm sure that was clear as mud

Yeah, I think I am more confused now then before!
Your description does not seem to match up with the sample data you posted, i.e.

Short story: I need to put "Ladder_" + value of cell A4 which is "C6" in the screen shot example. See yellow cells for reference

I am not seeing that in your example at all!

In any event, this seems very different than your original question, which was already answered.
As such, it would be best to post it to a brand new thread so it shows up as an unanswered question on the "Unanswered threads" listing that many people use to look for new questions to answer.

 

[londa_vba]

Yeah, I think I am more confused now then before!
Your description does not seem to match up with the sample data you posted, i.e.

I am not seeing that in your example at all!

In any event, this seems very different than your original question, which was already answered.
As such, it would be best to post it to a brand new thread so it shows up as an unanswered question on the "Unanswered threads" listing that many people use to look for new questions to answer.

Ok thank you anyways