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 [...]

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 content of the slide and [...]

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

Excel VBA – What is SPLIT Function?

Splitting people OR friends may not be a good idea :) but Splitting data or string becomes necessary to organize it and to put it in more readable format. Here in this article, you will learn about splitting the data/string which is joined with a specific delimiter. Delimiter could be any character or special character. This VBA function basically finds [...]

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 [...]