Forum Discussion
Solved
Excel, unbale to get a VBA macro working to hide rows
Hello everyone I can relaly use some help as my VBA macro abilities still need more practice. I have the tennis elbow to prove it becuase I am in pain. My project consists 7 Primary Funcito...
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.
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?
- Thank you.
Good to hear that it has been solved.
- I just got it working, seemed our in office comuters never got updated properly. Took a good hour to update and everythign runs fine now. My appologies for this frustration, but when it comes to part time telworking this is a new double edge sword issue we face in my workplace.
OK, but B5:B11 are populated correctly. I have no idea why the error occurs, since you use Microsoft 365 it should work. Sorry.
