-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,907
- Office Version
- 365
- Platform
- Windows
Don't confuse VB with VBA. They are not the same thing.
https://www.theregister.co.uk/2017/...shifted_microsoft_to_focus_on_core_scenarios/
https://www.theregister.co.uk/2017/...shifted_microsoft_to_focus_on_core_scenarios/
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
VBA is not going away, however, no improvements are slated to be made to the UI. The Object Model will continue to be updated as new features are released though.
There are investments being made in the JavaScript API's, which will enable extensibility on all endpoints. For that, see: ScriptLab. That's not at parity with VBA at this point, but new additions are made every week.
HTH
There are investments being made in the JavaScript API's, which will enable extensibility on all endpoints. For that, see: ScriptLab. That's not at parity with VBA at this point, but new additions are made every week.
HTH
