+ Reply to Thread
Results 1 to 3 of 3

Expressing worksheet name with arrayname(i) as address and want to hide this worksheet

  1. 12-13-2019, 07:47 PM #1
    curiousGrace
    curiousGrace is offline
    Registered User
    Join Date
    07-21-2009
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2019
    Posts
    13

    Expressing worksheet name with arrayname(i) as address and want to hide this worksheet

    Hi,
    The last line of code does not work. I am not sure how to address this problem. Thank you for your help.

    Here is my code


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-13-2019, 08:41 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Expressing worksheet name with arrayname(i) as address and want to hide this worksheet 

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 12-13-2019, 09:34 PM #3
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Expressing worksheet name with arrayname(i) as address and want to hide this worksheet

    Also you're not refering to the same sheet in your last codeline.

    On the 1st line you use i, in your second line you use 1

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
    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. [SOLVED] VBA for hide worksheet except active worksheet selected by Combobox
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 01-26-2018, 05:29 AM
  2. Delete & Hide Rows in a Worksheet based on the Value of a Cell in another Worksheet
    By lhickerson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2014, 09:53 AM
  3. Macro to hide rows on a worksheet, based on a cell's value on another worksheet.
    By buttercup116 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2014, 10:47 AM
  4. how to show/hide worksheet based on a dropdown form with 2 lines in another worksheet
    By shaunbuk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2012, 03:53 AM
  5. Using date format and left function with worksheet name to hide worksheet
    By rgullett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2012, 05:16 PM
  6. Hide/Unhide Rows in One Worksheet Based on Values in Cells in Another Worksheet
    By xponent_es in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2011, 03:26 PM
  7. VBA to show or hide columns in one worksheet conditioned on value in other worksheet
    By punsterr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2005, 05:05 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