i'm guessing you're trying to select a sheet in a non-active workbook. do you
have more than 1 workbook open?

--


Gary Keramidas
Excel 2003


"Robert Crandal" wrote in message
...
I am able to run the following code below:

Workbooks("DataBook.xlsm").Sheets(4).Activate

However, why does the following code give an error message:

Workbooks("DataBook.xlsm").Sheets(4).Select ' ERROR!!!


I thought a sheet "activate" call was the same thing as a sheet
"select" call. Can anybody explain what is going on here??


thank u