I'm trying to do the following...

1) Set a var equal to a cell value
2) I will then use a Select Case statement to decipher the value
3) Once I get the value, I'll set another value
4) I then need to put that resulting value in another cell location

The problem is I don't know how to get and set a value into cells in Excel.
If it were, say a Word form, I'd do something like...

Get a value from a form field in Word...

myVar = ActiveDocument.FormFields("myFirstMarker").Range.Text

Set a value in a form field in Word...

ActiveDocument.FormFields("myBookmark").Result = myVar

But I don't know how to start calling the sheet and how the syntax works for
locating a cell range??? I'd appreciate it if someone could tell me how to
do this in Excel...getting a value from one cell...and then putting a var
value into a cell.