Dear All, In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is...
Results for "sheet"
Excel VBA Tips – Two excel VBA Tricks to help in day-to-day Coding
Dear Readers, In this article I am going to share with you - Two little VBA code which will help you in your day-to-day coding life. 1. How to disable Copying Objects with cells through VBA When you are trying to move or copy a Sheet or set of Sheets in to...
CELLS() and RANGE() – Are they same? Are they Excel VBA Object?
Dear Friends, Many of you who are interested in excel Macro or if you have ever tried to read and understand a VBA code, you would have seen two ways of referring a cell in Excel Macro: Using Range() To refer value of Cell D4, you can use Range("B4").Value. To know...
Different ways of Reading RecordSet Object in Excel Macro
Dear Friends, In my previous article, I emphasized mainly on how to execute different kind of queries in database using Excel VBA. I covered one example How to display or spread a RecordSet in excel Sheet. But in this article I am going to focus on different ways of...
VBA to Query Database and Spread the Records in Excel
In continuation to one of my article which shares the connection strings to connect to different data bases. In this article I explained and shared every possible VBA code to make connection with many databases like Oracle, SQL etc. but does the Story ends there?? NO...
Excel Tip : How to Make an Excel Cell secured for Password
One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password text box which is masked and secured. I have tried to achieve that up to some extent but not 100%. Go through with this article and provide your...
VBA String Functions – INSTR() Function
Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to the VBA code let's have a look Where to see document properties in Excel Document? How to see document property of an Excel document Follow the below...
Excel OFFSET Function – Excel Tutorial
Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the...
Excel Trick – SMART Method to make White Background
Dear Readers, If you are a Microsoft Excel user then you must have come to a situation where you want to show you data in a particular area and rest all the area you want to make it plane white (without lines or grid). Something like depicted in below image:...
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 (=).
Download Free Add-in – File Manager
Dear LEM Readers, It's been long time since I wrote any article here. I was really busy in some personal work...
HP Quality Center – Create Folder Structure in Test Lab and Pull test Cases from Test Plan
Dear LEM Readers, In previous article, we learnt How to connect to HP QC using Excel Macro. In this article, we are...
How to insert a picture in excel using VBA
Dear Friends, In this article, I am going to teach you a simple VBA code, which help you in inserting a picture in...