When you setup Add-in A-Tools, in special situations It may raise error "Variant is null, cannot invoke" as screenshot below:
Reason:
1. Your comuper have not install Microsoft Office.
2. You are running Portable Office (Excel, Word, Powerpoint,...)
Solution:
You must install Micosoft Office! The lowest version is Microsoft Office XP, 2003, 2007, 2010, 2013, 2016, 2019, 365 or later.
When install please check install "Visual Basic for Application" (Setup default)
Add-in A-Tools run in Microsoft Excel it requets VBA to get full features.
Support online: https://www.facebook.com/groups/hocexcel/