Ready to Use 101 Powerful Excel VBA Code Just Copy - Paste - Run (For Functional Users)

133 Pages·2017·0.46 MB·English

by  Anil Nahar

Disclaimer
Ready to Use 101 Excel Powerful Microsoft Excel VBA Code is an
independent publication and is not affiliated with, nor has it been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
Trademarks
Microsoft, Visual Basic, Excel and Windows are either registered trademarks or
trademarks of Microsoft Corporation in the United States and/or other countries.
Liability
The purpose of this book is to provide basic guideline for people interested in
Excel VBA programming. Collection of ready code has been used on reality
platform by technical and non-technical users on their routine. Although every
effort and care has been taken to make the information as accurate as possible,
the author shall not be liable for any error, harm or damage arising from using
the instructions given in this book.

ISBN: 9781973519478

All rights reserved. No part of this book may be reproduced or transmitted in any
form or by any means, without permission in writing from the author.
Acknowledgement
I would like to express my sincere gratitude to many people and Excel Learning
Websites who have made their contributions in one way or another to the
successful publication of this book.
My special thanks go to my Parents and Gurudev (Acharya Sh Ramesh) and
friend Mr. Rakesh Jain (Charvi Associates) having expert knowledge of web
programming & My Accounts, HR, IT & ERP Departments Colleague
contributed their ideas and even wrote some of the sample programs for this
book. I would also like to appreciate the support provided by my beloved wife
Manisha Jain, son Master Samkit and youngest daughter Samiksha Jain and
Friends.
I would also like to thank the million of visitors to my Smart Excel & Learning
website at http://www.anilnahar.com l for their support and encouragement.
About the Author
Anil Nahar holds a Master degree in Computer Application (MCA), a
Bachelor degree in Commerce (B.Com.) and Three year completed C.A.
training by ICAI ( Institute of Chartered Accountant of India). He is working on
real platform with a esteem organization on Functional as well as Technical
Support in Excel. He is provided many smart excel training programmes in
corporate and appreciated by management. He has been involved in
programming for more than 10 years. He created the popular online Smart
Learning Tricks Tutorial at www.anilnahar.com in 2017 and since then the web
site has attracted millions of visitors and it is one of the top searched VBA Excel
websites in many search engines including Google.
Table of Contents
How to Insert VBA code to Excel Workbook
How to run VBA macros in Excel
Adding Or Subtract By Specific Value To All
Alphabets Serial Capital And Small Letter
Auto Fit Columns
Auto Fit Rows
Auto Save And Close Workbook
Automatically Invoice Number Generator
Blank Cell Fill With Zero Value
Calculator Open
Change Multiple Field Settings In Pivot Table
Chart Heading Mark
Combine Duplicate Rows And Sum The Values
Convert Columns And Rows Into Single Column
Convert Month Name To Number
Convert Negative To Positive Value
Convert Number To Month Name
Convert One Cell To Multiple Rows
Convert Text To Column
Count Number Of Words In Selected Range
Count Total Words In Worksheet
Create A Monthly Calendar
Create Folders Based On Cell Values By Selection Range
Cube Root To All
Data Entry Form Of Activate Sheet
Delete All Blank Worksheets
Delete All Worksheets
Delete Apostrophe In Text Or Number
Delete Decimal Value
Delete Every Other Row In Selection
Delete Input Value In Range
Fill Blank Cells With 0 Or Other Specific Value
Find Duplicates Value From Two Columns
Hide All Inactive Worksheets
Highilght Specific Text
Highlight Alternate Rows With Color
Highlight Color Maximum Ten And Other Number
Highlight Color Of Duplicate Value
Highlight Greater Than Value By Input
Highlight Highest Value
Highlight Lowest Value
Highlight Mispelled Cell Text
Highlight Name Range Values
Highlight Negative Number
Highlight Text With Color Based On Second Column
Highlight Unique Value
Image Conversion Of Selection Area
Image Creation Of Chart
Image Linked Of Selction Area
Import All Files Path And Summary Of Folder And Sub
Folder
Import Multiple Text Files
Index Worksheets With Hyperlink
Indexing All Worksheet Name In Of Active Workbook
Indexing Name Of Files In Windows Folder
Insert Worksheets
Insert Columns
Insert Header And Footer By Input Text
Insert Header And Footer Current Date
Insert Rows
Inserting All Worksheets Names In Cells
Lock Formula Cell
Lower Case All
Merge All Worksheets Of Active Workbook Into One
Worksheet
Multiply By Specific Value To All
Password Breaker Workbook
Password Breaker Worksheet
Password Protect Without Unprotecting Worksheet
Password Protected Workbook
Password Unprotected Workbook
Pivot Table Update Auto
Print And Print Preview To Area By Input
Print Comments In Last Page
Print Multiple Selection Range Only
Proper Case All
Protect And Unprotect Worksheets
Protect To Other Insert Worksheet
Remove Blank Rows Of The Selected Range
Remove Entire Rows Based On Cell Value
Remove Leading Spaces
Remove Wrap Text
Rename All Sheets By Entering A Specific Name
Rename Worksheets By A Specific Cell Value
Repeat Cell Values X Times
Save As Worksheet To Workbook
Select All Bold Cells In A Range
Select Entire Column Except Header