New to Excel Macro ?

This category holds articles which are for the beginner to Excel Macro. If you are new to Excel Macro then this is the right place for you.

Image in Signature not Displayed – Mail Sent by VBA

Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In order to get rid of this problem there are two solutions. outlook Signature [...]

[VIDEO] Excel Macro Tutorial-Part-1-Introduction to Excel VBA

Dear Readers, Recently, I realized that Videos/audios are sometimes more easy medium for a blogger like me who is mainly teaching some new things in Microsoft Excel area, to convey the message in a very appropriate way. At the same time, for a reader as well it is very easy to learn things by watching the video rather reading some [...]

VBA Beginners: How to write macro for a Command Button

Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3 simple steps by which you [...]

How to find Visible Range in Excel window on a Screen

Dear Friends, Its been a while I posted any post here. I am back with so many interesting stuff for you in Excel VBA. Here is a very small but useful excel vba tip for you. This is about knowing the range which are currently visible to the user on his/her screen. Do not get confused with the visible or [...]

Excel VBA Basics : All about Debugging Excel VBA code

Dear All, Debugging VBA Code 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 not a problem. As long [...]

Complete VBA tutorial to interact with Power point Presentations – Part – 1

D ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so many questions around this topic. Questions, which were, mostly, asked were like - Sample List of Questions...   VBA code to create a presentation slide based on a [...]

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 another workbook then by default it copies [...]

Excel VBA – What is SPLIT Function?

Split 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 to put it in more readable format. SPLIT-function Here in this article, you will learn about splitting the data/string which is joined [...]

How to assign a Shortcut key to a Procedure or Subroutine

Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I am back with many more amazing articles now. All your un-answered questions will be answered in few days with a set of few interesting articles which will make you awesome in excel VBA [...]

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 language, Macro is very popular software available with [...]