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.
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.
Do B5, B6 etc. populate with the appropriate versions?
This one is a column sheet I created piggy backing off the one you posted.
Again the one you last posted , it also is not working same error.
