Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. I have already written an article where I have explained a lot about deleting worksheets using Excel VBA. In this...
Results for "delete"
How to delete sheet using Excel Macro
Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. In this article, I am going to teach you all about deleting the Sheets from a workbook through Excel VBA. There...
Excel Macro : Excel VBA code to Protect OR UnProtect Sheet
This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming the fact here that you know How to Protect or UnProtect a Sheet using Excel In-Built function . For those who do not know protect or unprotect...
Implicit and Explicit declaration of variables in VBA
Hello friends, In the Article related to variables in VBA, I had explained following things: 1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of...
ADO RecordCount Property – RecordSet Object
The RecordCount property returns a long value that indicates the number of records in a Recordset object. Many a times you might have observed that RecordCount Property does not return a correct number instead it always returns a number -1. RecordCount Property...
Excel Macro Tutorial : What is Excel Macro ?
Dear Beginner, In this Excel Macros Tutorial, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let's begin with What is Excel Macro What is Excel Macro ? Let's not get too much in detail at this point. For now, in simple...
Complete guide to Message Box in Excel VBA [FREE DOWNLOAD]
Creating a message box in Excel VBA (Visual Basic for Applications) is a useful way to interact with users and provide information or gather input. In this article, I will guide you through the process of creating a message box in Excel VBA, covering all the possible,...
Tutorials
Connect to HP QC using Excel VBA Create Folder Structure in Test Lab and Pull test Cases from Test Plan Download Test Cases from HP QC with Design Steps Download Test Cases from HP QC without Design Steps How to connect to Access Database...
Welcome to my blog
Thanks for visiting this...
About Page
Who am i? My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience. In 2014, I married my Love, Shagun and we are living...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
VBA: Reverse a string
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
Data Anonymizer: Open Source to Anonymize Personal Data
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Custom Excel Formula to Count based on Color
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...