+ Reply to Thread
Results 1 to 10 of 10

Referencing Sheet Code name

Hybrid View

rjnc Referencing Sheet Code name 09-21-2015, 12:33 PM
TMS Re: Referencing Sheet Code... 09-21-2015, 12:43 PM
rjnc Re: Referencing Sheet Code... 09-21-2015, 01:04 PM
TMS Re: Referencing Sheet Code... 09-21-2015, 02:46 PM
rjnc Re: Referencing Sheet Code... 09-22-2015, 04:48 AM
romperstomper Re: Referencing Sheet Code... 09-21-2015, 03:51 PM
rjnc Re: Referencing Sheet Code... 09-22-2015, 04:45 AM
TMS Re: Referencing Sheet Code... 09-22-2015, 05:26 AM
rjnc Re: Referencing Sheet Code... 09-22-2015, 08:27 AM
TMS Re: Referencing Sheet Code... 09-22-2015, 09:08 AM
  1. 09-21-2015, 12:43 PM #1
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,093

    Re: Referencing Sheet Code name 

    ?sheet1.CodeName
Sheet1
?sheets("Sheet1").codename
Sheet1
?sheets(1).codename
Sheet1

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  2. 09-21-2015, 01:04 PM #2
    rjnc is offline
    Registered User
    Join Date
    10-11-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Referencing Sheet Code name

    Quote Originally Posted by TMS View Post 
    ?sheet1.CodeName
Sheet1
?sheets("Sheet1").codename
Sheet1
?sheets(1).codename
Sheet1

    Regards, TMS
    Thanks TMS, however when i run the code and replace the Worksheets("report1442310827144") with sheet1.codename i get an error message '438' Object doesnt support this property or method.

    Is there something i am doing wrong?

    Cheers,
    RJNC
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sorting while referencing a cell + referencing from another sheet
    By cjo123 in forum Excel General
    Replies: 0
    Last Post: 01-09-2013, 06:58 AM
  2. Referencing original sheet to copy/paste into new sheet without using file name
    By pgarakani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2012, 02:06 PM
  3. Referencing sheets with a sheet number as opposed to sheet name
    By spawn2048 in forum Excel General
    Replies: 5
    Last Post: 03-14-2012, 12:42 PM
  4. Optimizing the Vlookup code in VB. Repitive code with different referencing range.
    By raknahs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2010, 05:03 PM
  5. referencing different sheet in code
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2008, 11:29 AM
  6. referencing data on another sheet using row and column headers from current sheet
    By p1tbullz in forum Excel General
    Replies: 8
    Last Post: 02-03-2007, 01:41 AM
  7. Referencing code outside of current sheet
    By nemadrias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2006, 03:30 PM
  8. [SOLVED] referencing a sheet named in a cell then using data from that sheet
    By gbeard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2005, 04:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1