I am attempting to write code that will activate a particular workbook based
upon a workbook name that is entered into cell d2. Below is my feeble
attempt that is not working... any help is appreciated.

Dim x As Range
Set x = Range(D2)

Workbooks (x).Activate