Assign a Variable a Value

[NewToExcelGlenn]

Hello. Just signed up and am amazed at all the stuff one cando with Excel and VBA.
I only know a handful of VBA codes and hope to learn alittle more and contribute where I can.
I have my sports team files that I use as a hobby andrecently found out about VBA and how some things can be automated.
I’m gonna try and create an Excel macro and was wondering ifI could ask a question.
I’m looking to assign a value to a variable. (I think I havethose terms right).
Its like this:

TeamPR = ‘ the value that’s in the last cell in column C

I tried looking it up on the internet, but not knowing toomuch I got confused.
If anyone wants to share this code, it would be sincerelyappreciated.
Thanks very much and have a great day and weekend.

 

[PatOBrien198]

Sub Macro1()
    Dim myValue
    
    myValue = Range("C" & Columns("C:C").Rows.Count).End(xlUp).Value
    MsgBox myValue
End Sub

 

[NewToExcelGlenn]

Sub Macro1()
    Dim myValue
    
    myValue = Range("C" & Columns("C:C").Rows.Count).End(xlUp).Value
    MsgBox myValue
End Sub

That works, Pat!

Thanks very much!