LinkBack URL
About LinkBacks
Hello. I need to hide entire row 4 if H4 is empty, then row 5 if H5 is empty and so forth. I use the code below, but I guess I've got problem with IsEmpty(i, 8).. Any idea?
Please Login or Register to view this content.
Hello. I need to hide entire row 4 if H4 is empty, then row 5 if H5 is empty and so forth. I use the code below, but I guess I've got problem with IsEmpty(i, 8).. Any idea?
Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this..
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
@Hi Sixthsense, works like a charm. How would you do the same to hide if #N/A? Cheers
Please Login or Register to view this content.
@Debraj - unfortunately this line: "If Cells(i, 8) = vbNullString Then" makes problems..
Here's yet another, though similar way of doing the same using the LEN function:
HTHPlease Login or Register to view this content.
Robert
Last edited by Trebor76; 09-02-2013 at 07:26 AM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
@Robert/AB33; thanks for adding: Application.ScreenUpdating = False and then True ... it helps though I've got less than 500 rows
You're awesome, thanks everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks