Register Yourself for FREE Session on “Basics of Excel VBA”

Dear Readers,   LearnExcelMacro.com is going to conduct a FREE online session on “Basics of Excel VBA”. This session is going to be conducted on Google-Hangout hence to receive an invite for this FREE session you need to register yourself by submitting the below form. If below form is not visible properly, kindly click on …. Click here to Read More >>

Wishing you and your Family a Very Happy Diwali

Wishing you a very Happy Diwali to you and your family. May this Diwali brings health, wealth and prosperity in your life. May this festival of Lights brings light in each one of your life For my readers who does not know about this festival: This an Indian Festival called as “Festival of Lights”. It …. Click here to Read More >>

Interacting with Powerpoint Slides – Tutorial – Part 1

Brief about the Tutorial In this tutorial, I am planning to write 3-4 articles which will be all around Microsoft Power Point Presentation but using Excel Macro. So as part of this tutorial you will basically learn how to Open, Close, save, Copy a slide from one Presentation to other, deleting a slide, modifying the …. Click here to Read More >>

Excel VBA – Few little help in your 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 using VBA When you are trying to move or copy a Sheet or set of Sheets in to another workbook …. Click here to Read More >>

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 more about RANGE() you …. Click here to Read More >>

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 have defined, …. Click here to Read More >>

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 reading RecordSet Object. How to get …. Click here to Read More >>