Thread: Can I refer to a sheet in another book by its codename?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_1346_] Simon Lloyd[_1346_] is offline
external usenet poster
  
Posts: 1
Default Can I refer to a sheet in another book by its codename?

You reference a sheet codename like this Sheet(1) however, you cannot
use a sheet codename when you reference a Sheet that is in a different
Workbook to the one that the code is in.

Michelle;723812 Wrote:

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


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=202735

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote