Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate-level users also do not know about all these options to comment on a line or group of lines in Excel VBA. Like every other programming language, VBA too has...
Results for "comment"
Excel VBA Tips: How to comment or uncomment a Block of Code in VBA
Dear Friends, Providing proper short descriptions for each of your functions or statements etc. makes your VBA code - easy to read, easy to understand by anyone who refers your code. Now the question is, how can you write description in English language in between...
Excel Macro Beginners – What is Range Object in Excel VBA
Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I...
Excel VBA – What is SPLIT Function?
plit is the hardest shot to hit in Bowling. But unlike bowling SPLIT is very simple function to use in excel VBA. Splitting data or string in VBA, sometimes becomes necessary to organize it and...
Top 10 Useful Excel Macro [VBA] Codes Examples – [For Beginners]
Microsoft Excel is a powerful tool for data analysis and reporting. However, you can supercharge your Excel experience by using VBA (Visual Basic for Applications) to automate tasks and extend Excel's capabilities. In this blog post, we'll explore the top 10 VBA code...
Difference between .Text, .Value and .Value2 in Excel VBA
One of you raised a question about which property should I be using to get the value of a cell or range - . Text, .Value or .Value2 Most of the time you might have seen all 3 methods being used interchangeably. Rather than answering them in a comment, I thought of...
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...
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance calculator API was also affected by those changes. I had written an article long back about how to calculate distance and time taken between two places in...
Methods to save a Macro FREE copy of a workbook [FREE DOWNLOAD]
Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a time before sending your workbook with Excel VBA Macro code in it, you want to save your workbook without any VBA code in it. Therefore here in this article, I will show you - how to save...
40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a previous article, I published the first 20 examples. Download a FREE Excel Workbook with all 40 Examples At the end of this article, you will have a...
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...