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
|