Forum Discussion
Excel, unbale to get a VBA macro working to hide rows
See the attached version.
If the end date is left blank, it will work as before.
If you enter an end date, ALL sections that overlap the period from start date to end date will be displayed.
The formulas now use Sheet3. I left Sheet1 in the workbook, but it is not used anymore.
Thank you so very much!
You have no idea how must elbow pain I have been in this past week trying to figure this out and creating the branching questions.
I have a follow up question to this sheet.
Lets say I had to had an end date, say B3 for example.
How different would that be if the dates overlapped into 2 or 3 versions?
I am worried we may need to add that down the road.
Thank you!
See the attached version.
If the end date is left blank, it will work as before.
If you enter an end date, ALL sections that overlap the period from start date to end date will be displayed.
The formulas now use Sheet3. I left Sheet1 in the workbook, but it is not used anymore.
question , I was working from home yesterday and everything worked fine . I sent this to my work computer and made no changes , for some reason I am getting a Run Time error 13, type mismatch. Case “Preversion-1” is highlighted yellow. Is this because I’m using my work pc?
What do the cells B5:B15 contain? Is there a cell among them that displays an error?
- I made no changes to the sheet you last provided. I re downloaded here at my office. Technically all that would be needed is B5:B11 as there is only 7 versions required. I created another excel sheet, tweaking it to columns not rows. Everything worked flawlessly at home.
- You are a life saver! Big thanks I greattly apprecite your asistance! Now we have both options avilavable, this saves us a lot of time reviewing cases. It has been a long time I felt this great on a Monday morning!
