Excel Tips

This category holds all the Posts which are related to Excel Tips

Top 4 VBA Methods to Export Excel data as CSV File

In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA.

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

What if you do not have internet ??

Wait.. this is supposed to be an Excel Blog.. right? Then why such article here? Am I going to discuss about this biggest problem of the World ;) i.e. Internet Not Working?? Or Have I got some excel macro which will fix your Internet Connection problem. Or an Excel Macro to boost your WiFi Signal?? Internet Connection Not Working [...]

Windows FileDialog to Select File or Folder Path in VBA

Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through windows file explorer window. It is the same window which you might have seen in windows for selecting a file. [...]

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

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

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

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

Excel Tip: How to refer characters using ASCII Value

Hello friends, In this article, I am going to explain you, how can you use special characters in Excel VBA and formulas without breaking the syntax. For Example: You can not use double quote or any other Special Characters, which are generally a part of Formula Syntax,  directly in a cell while using formula because using them, will spoil the [...]

Page 1 of 41234