Changing Contents of a Specific Cell

[MR3]

In my vba macro I was wondering how to change the Contents of a specific cell.
Lets say C1. to "Address" but currently the contents of C1 are "Name".

 

[Anthony47]

For examplE

Range("C1").Value = "Address"

Bye