Blog

Read Welcome Message..

Are you visiting LearnExcelMacro.com first time?

Welcome to the learnexcelmacro.com. Do not forget to read .. welcome message written for you...
Read Welcome Message..

Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question by providing a piece of code. Though there were some [...]

[Personal] Wish you a very happy Diwali

Dear readers, Wish you a Very happy Diwali :). Diwali is an Indian festival. It is called festival of lights. On this eve people lights lot of Dias, Candles etc. All the places, houses, shops will be scintillating by all different kind of lights and frills. Like any other Indian festival, this also involves meeting and greeting with family, friends, [...]

By |Categories: Personal|Tags: , , |0 Comments

[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel

Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, tricks which will be useful for you during development of any Excel VBA tool. YouTube Channel You can subscribe to LearnExcelMacro.com Channel where all the videos are going to be uploaded. You will be notified [...]

[VIDEO] Excel Macro Tutorial-Part-2- Your first VBA Program

Dear Readers, Here is the second episode of the Excel Macro Tutorial for Beginners. If you have not watched the first part of the Tutorial, you can watch it here or on the YouTube Channel. Kindly provide your feedback on this video. Any improvements/ suggestions are always welcome. You can provide your feedback by typing comments in this article or [...]

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

Button to Zoom in a Graph in Excel – [Method 2]

Hello Friends, How are you doing? I am back with my next article about "how to make a button to zoom-in and zoom-out a graph in Excel VBA". this is the second method I am going to explain you. In my previous article, I had explained about the very basic method. There were 4 limitations in the previous method which [...]

[Video Tutorial] How to add controls like command button in excel [For Beginners]

Hello friends, I have created a Youtube channel where I am going to share many more recorded video tutorials for beginners, intermediate and advanced users. Don't want to miss any of the video? Then Subscribe to my Youtube Channel. Subscribe my channel on Youtube Do not forget to share and comment your thoughts about the video tutorials in the comment [...]

Button to Zoom in a Graph in Excel – [Method 1]

I wish Microsoft Excel has a built-in feature to Zoom-in and Zoom out a graph made in Excel 🙂 like many other web applications. But not to worry, you can easily create one to simulate the Zoom-in and Zoom out feature on an Excel graph. There are more than one workaround to achieve this. Though each workarounds are having few [...]

How to Get Excel version using VBA Code

Dear Friends, Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work. For Example: If you have some sales data using more than 256 columns then if user is using Excel [...]

Invoice Template [ FREE Download ]

Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my articles, tools repository and excel assignments in excel spreadsheets too. I thought of sharing with you all the invoice template which I [...]