Thread: Can I refer to a sheet in another book by its codename?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
  
Posts: 204
Default Can I refer to a sheet in another book by its codename?
I want to refer to sheets' codenames that are set up in the active book from
another book (or an add-in)

e.g. MsgBox ActiveWorkbook.SheetCodeNameHere.Cells(6, 2).Value

Can I do that?


M

Reply With QuoteReply With Quote