Hi,

I want to activate a sheet in Run time. Can anyone explain to me wh
of the following two bits of code, the first one work but the secon
doesn't.

Set monthSheet = baseBook.Sheets("Month")
monthSheet.Activate

Set currSheet = baseBook.Sheets(sheet)
currSheet.Activate - error message "Out of Range"

Cheers, J

--
Message posted from http://www.ExcelForum.com