I have a macro that copies specific data from one workbook to another.
I need to be able to reference a specific sheet in that other workboo
absolutely.

The macro checks that the workbook to copy the data into is open tha
then stores that workbook in a variable.

Set OtherWorkbook = Workbooks("Other Workbook.xls")

Now i need to refer to another sheet in the workbook absolutely i
order to select it.

OtherWorkbook.Sheets(XX) won't work because the index number change
when the sheets are moved around, which will be changed by the user.

OtherWorkbook.Sheets("Tab Title") won't work because that has a goo
possibility of being changed by the user.

I'd like to use the Sheet (Name) property in VBA, but syntax like:
OtherWorkBook.Sheet12.Select doesn't work either.

Thanks

--
Brassma
-----------------------------------------------------------------------
Brassman's Profile: http://www.excelforum.com/member.php...fo&userid=1329
View this thread: http://www.excelforum.com/showthread.php?threadid=49553