+ Reply to Thread
Results 1 to 4 of 4

current worksheet

Hybrid View

  1. 01-24-2007, 12:57 PM #1
    jtwork
    jtwork is offline
    Forum Contributor
    Join Date
    12-20-2006
    Posts
    127

    current worksheet

    what is the code to apply the current worksheet to a string inorder to store that value?
    Reply With QuoteRegister To Reply
  2. 01-24-2007, 04:10 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

    Do you mean

    ActiveSheet.name

    or ActiveWorkbook.Path

    ?
    Martin
    Reply With QuoteRegister To Reply
  3. 01-24-2007, 04:11 PM #3
    jtwork
    jtwork is offline
    Forum Contributor
    Join Date
    12-20-2006
    Posts
    127

    worksheet please

    worksheet please
    Reply With QuoteRegister To Reply
  4. 01-24-2007, 05:20 PM #4
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    MyString = ActiveSheet.name
    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)

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