- Devi Ahilya VishwavidyalayaComputer Science, 2004 - 2007Bachelor's in Computer Science
- InfosysSoftware Test Analyst, 2007 - present
[YouTube Video] Excel macro Tutorial - Part -1- An Introduction to Excel...
Excel Macro tutorial for beginners level - part 1. What is Excel VBA and what difference between excel VBA and Excel macro 4.0. History of E
Learn Excel Macro Excel Macro Beginners - What is Range Object in Excel VBA
A complete Overview of Range Object in Excel Macro. This a tutorial of excel beginners which explains each and every aspects of Range Object
Learn Excel Macro Different ways of Reading RecordSet Object in Excel Macro
For DBCol = 0 To RecordSetObject.Fields.Count - 1 Worksheets("Data").Cells(xlRow, xlCol).Value = RecordSetObject(DBCol).Name xlCol = xlCol +
Learn Excel Macro Query Database and Spreading the Records in Excel - VB...
Excel Macro to execute an INSERT, UPDATE, DELETE Statement in DB. Queries which does not return any record after running, can be executed by
Learn Excel Macro How to refer Values from a Named Range - Excel VBA
I am writing this new article about , How can you read values stored in a Name range in Excel Sheet using Excel VBA. See Excel Macro to read
Learn Excel Macro Excel Tip : How to Make an Excel Cell secured for Pass...
An Easy way to make your excel cell behave like a Password TextBox where your password is masked and no one can see or copy your entered pas
Learn Excel Macro Excel Macro : Excel VBA code to Protect and UnProtect ...
Hello Friends,. This is a small VBA code to help you in dealing with Protecting and UnProtecting the WorkSheet using Excel Macro. Assuming t
Learn Excel Macro Excel Macro : Excel VBA code to Print the Sheet
YourObj (Required): It is a variable which represents your Object which you want to print. For example: Workbook, Worksheet, Chart etc. From
Learn Excel Macro How to Send an Email using Excel Macro from Gmail or Y...
Dear Readers,. In this article we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro
Learn Excel Macro Excel Macro Tutorial : Excel Form
Dear Beginner,. In this article I am going to explain every aspects of VBA Form. User forms in Excel is really nice to see. It looks very fa
Learn Excel Macro VBA String Functions - 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 i
Learn Excel Macro Excel Trick - Sheet Protection - Protect it and Stay Free
Dear Readers,. I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To
Learn Excel Macro 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
Learn Excel Macro Spreading data across Columns in Excel Without VBA Code
In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to explain you how to separate
Learn Excel Macro Excel Trick - SMART Method to make White Background
How do we do this formatting GENERALLY? Generally we follow the below steps to achieve this formatting: Step 1. Select the whole sheet by cl
Learn Excel Macro How to create User Defined Function in Excel
Dear Readers, User Defined functions (UDF) is also known as Custom Functions (formulas) in Excel. Previously I have created many different U
Learn Excel Macro Custom Formula to Reverse a String in Excel
Dear Friends, This is a very small but useful Custom Function which can be used to reverse a string in excel. In VBA (Excel Macro) there is