Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Asap utilities user guide ASAP Utilities user guide how to get the best out of this Excel add-in C CASAP Utilities user guide how to get the best out of this Excel add-in author pages latest revision ASAP Utilities version Bastien Mensink April ? - A Must

ASAP Utilities user guide how to get the best out of this Excel add-in C CASAP Utilities user guide how to get the best out of this Excel add-in author pages latest revision ASAP Utilities version Bastien Mensink April ? - A Must in Every O ?ce BV Bastien Mensink Eekwal LB Zwolle The Netherlands www amustineveryo ?ce com www asap- utilities com Information in this document is subject to change without notice Except as permitted by such license no part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical recording or otherwise without the prior written permission of the author While every precaution has been taken in the preparation of this user guide the publisher and author assume no responsibility for errors or omissions or for damages resulting from the use of the information contained in herein Microsoft Microsoft O ?ce and Excel are registered trademarks of Microsoft Corporation C CFREQUENTLY UPDATED ASAP Utilities User Guide Contents CONTENTS INTRODUCTION Intended audience The Excel screen in English GETTING STARTED How to get a copy of ASAP Utilities System requirements International versions of Excel O ?ce Update Windows update Installation Automatic installation Manual installation Excel XP Manual installation Excel Upgrade to a new version DLL registration administrative privileges Network installation Macro security Message Macros are disabled Trusted sources How to operate ASAP Utilities How to use ASAP Utilities in your own macros Undo Not all tools in ASAP Utilities have an undo No undo in macros by design of Excel Uninstall Automatic Automatic uninstall Manual Temporarily uninstalling ASAP Utilities User data and registry settings Registry Favorites menu Add ASAP Utilities to the Excel menu for all users Contents CASAP Utilities User Guide FREQUENTLY UPDATED Registering the DLL Registration license settings PURCHASE ASAP UTILITIES When to buy a license Key bene ?ts of registration How to order Instant delivery Secure ordering How to turn ASAP Utilities into a registered version LIST OF TOOLS The menu bar Short descriptions Vision control Favorites Shortcuts Select Sheets Range Columns Rows Numbers Text Formula Fill Format Objects Comments Web System Information Import Export Start ASAP Utilities Options Find and run a utility Info EXTRA WORKSHEET FUNCTIONS Worksheet functions ASAPFullFileName Chapter CFREQUENTLY UPDATED ASAP Utilities User Guide ASAPFileName ASAPFilePath ASAPSheetName ASAPCountShades range ASAPCellColorIndex range ASAPFontColorIndex range ASAPSumByFontColor range color number ASAPSumByCellColor range color number ASAPCountByCellColor LookinRange ColorIndexNr ASAPCountByFontColor LookinRange ColorIndexNr ASAPGetComment range ASAPGetHyperlink range optional sNA ASAPSpellNumber ASAPExtractNumbers ref ASAPStripNumbers ref ASAPGetFontName range ASAPGetFontSize range ASAPGetNumberformat range ASAPIsFormula range ASAPCountChar SearchText SearchValue ASAPExtractFilename FullFilename optional separator ASAPExtractFolderName FullFilename optional separator ASAPGetFormula FormulaCell ASAPGetFormulaInt FormulaCell ASAPMergeCells inputrange delimiter skipemptycells ASAPRandomPassword length usesymbols ASAPIsBold range Examples Remarks on distributing Remarks on calculation HOW TO Introduction How to examples TROUBLESHOOTING FAQ Bug report guidelines The basics what you did what you wanted and what happened Contents CASAP Utilities User Guide FREQUENTLY UPDATED Excel and windows version Always search our website and documentation ?rst Be brief but don't