Easy one
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Easy one

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    All I need to do is have a cell that displays the worksheet name.

    I figured "=sheetname" or something to that effect. I've been checking for a while and oddly enough I can find no answers.

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you are on the right track, if you just want the name of the active sheet, then the following code will work

    ActiveSheet.Range("A1") = ActiveSheet.Name

    hth
    lantiger

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    This can also be accomplish with the following formula rather than vba.

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
    It's never too late to learn something new.

    Ricky

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com