This is a bit complicated to ask but frankly i cannot figure it out myself, my range starts from row 32 and ends in row 277, i'm trying to have a code that would hide every 2nd row and continue hiding for 4 rows (including the 2nd row) in my range. So keep row 32, 37, 42, 47, 53, 57, 62, 67 ..... etc. visible and at the same time keep rows 33-36, 38-41, 43-46, 48-51, 53-56, 58-61....etc. hidden.
Of course i can do this with looping but that causes the code lag.
Thank in advance.
If you're saying you don't want to use a loop to populate the range array, you can manually type in the rows like:
If you don't mind using a loop to populate the rows, then hiding them all at once, then:
Please Login or Register to view this content.
Edit: That last sub works if the loop goes to 203. At 208 or higher, I get a 1004 error. Any one know why? Is there a maximum length of a string that can go in Range() or something?Please Login or Register to view this content.
Last edited by walruseggman; 09-22-2016 at 05:15 PM.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Hello walruseggman,
This line is where the problem is:It does not reference the correct Rows to be hidden. it Shows hde = "33:3638:41"Please Login or Register to view this content.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hmmm, not at all what I m seeing. Can you post an example workbook that mirrors those results, please?
@walruseggman,
I don't have a sample Workbook, tested in a new Book, and the Code stops at this line; Range(hde).EntireRow.Hidden = True, and is highlighted in yellow. Now when you hold your cursor over (hde), it shows that it holds the range as "33:3638:41"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks