Hi All,
i'm looking to hide rows based on the following
in Column C i have numbers that have a gap in between rows for the next set , my request is how do i hide when in a set (like 1 to 5 in the first set) i want to hide 1234 and show the row showing 5 only ....next set is 12 so hide row with 1 and show the 2 etc ....the 1's on their own stay....any clues would be greatly appreciated
1
2
3
4
5
1
2
1
1
2
3
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
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
Hi 6th,
Thanks for your reply!
Ran that (changed to C:C)
nothing happened?
Code to me looked ok
Please check the attached fileOriginally Posted by BrisbaneOz
weird stuff , your sheet works mine doesn't?
appreciate your help heaps
Hi 6th
I worked it out (my data cell had a formula that produced that result 12345 etc) once i copied and pasted special all values your code worked
Thank you so very much.
Last edited by BrisbaneOz; 07-30-2020 at 01:16 AM.
May be the blank cells which appears as empty cells is not actually blank.
Copy paste the below formula in a cell
Formula:
Please Login or Register to view this content.
In the above formula change the C5 to your blank cell and see what result you get. If it shows True then the cells is actually blank and if it shows False then it is a non blank cell.
Hi 6th,
All is well
working perfectly
Above works perfect, now i am trying to delete rather than hide in the above code by changing
r.Cells(1).Resize(r.Cells.Count - 1).EntireRow.Hidden = True
to
r.Cells(1).Resize(r.Cells.Count - 1).EntireRow.Delete = True
but does not work , does anyone have any clues?
lol i'm going crazy - remove the =True and all is good
please ignore it's early morning in Australia - that's my excuse anyway!
Last edited by BrisbaneOz; 08-27-2020 at 05:09 PM.
Glad you fixed it and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks