+ Reply to Thread
Results 1 to 5 of 5

Need Help with VBA code for unhide and hide in excel

  1. #1
    Registered User
    Join Date
    12-08-2018
    Location
    MEMPHIS
    MS-Off Ver
    2010
    Posts
    8

    Lightbulb Need Help with VBA code for unhide and hide in excel

    Hi this is my code for when someone enter into the cell, the code would hide and unhide the rows, however I am having a problem when I add a letter to the code it would not work this is the code
    Please Login or Register  to view this content.

    I need to add for example down below where the 6061 is I need to be able to add 606hb001( letters to the word and the code still work. Please help.

    (
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 12-08-2018 at 05:09 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Need Help with VBA code for unhide and hide in excel

    Quote Originally Posted by kimparker0261 View Post
    I need to add for example down below where the 6061 is I need to be able to add 606hb001( letters to the word and the code still work. Please help.
    That English is a little confusing but do you mean this:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-08-2018
    Location
    MEMPHIS
    MS-Off Ver
    2010
    Posts
    8
    Quote Originally Posted by 6StringJazzer View Post
    That English is a little confusing but do you mean this:

    Please Login or Register  to view this content.
    Thanks another question
    How can I asked the saw question for a series of cell meaning if cell h10 though h48 say 606hb001 then unaided cell 48 to 90 for example

  4. #4
    Registered User
    Join Date
    12-08-2018
    Location
    MEMPHIS
    MS-Off Ver
    2010
    Posts
    8
    Quote Originally Posted by kimparker0261 View Post
    Thanks another question
    How can I asked the saw question for a series of cell meaning if cell h10 though h48 say 606hb001 then unaided cell 48 to 90 for example


    Sorry see this question
    for a series h10:h48 is equal to 606hboo1 then hide rows 56:75

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Need Help with VBA code for unhide and hide in excel

    Quote Originally Posted by kimparker0261 View Post
    for a series h10:h48 is equal to 606hboo1 then hide rows 56:75
    Do you mean if every cell in H10:H48 is "606hboo1" then hide rows 56:75?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Which below code, I can Hide & unhide, but I want only allow to HIDE
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2016, 04:10 AM
  2. VBA Code for Hide/Unhide Cells
    By Kahar007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2016, 10:55 AM
  3. [SOLVED] Different ranges for hide/unhide with vba code
    By Immortal2014 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2015, 06:07 AM
  4. Help with VBA Code (Hide/Unhide Worksheets)
    By maryren in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 12:43 PM
  5. [SOLVED] Hide Unhide Code
    By ando185 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 01:22 PM
  6. Code to Hide and Unhide Rows
    By jcoulter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2012, 10:38 AM
  7. VBA code to hide/unhide columns
    By radline2006 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2011, 05:44 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1