cell reference
 

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

cell reference
 

Hi
you may try
workbooks(x.value & ".xls").activate

Note: The other workbook has to be open for this statement!

"hurlbut777" wrote:

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