Excel Tips

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

Regular Expression and its usage in Excel VBA

Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some simple regular expression patterns which are more often used. Refer the following [...]

By |Categories: Excel Functions, Excel Macro, Excel Tips|Tags: , , |Comments Off on Regular Expression and its usage in Excel VBA

Methods to save a Macro FREE copy of a workbook [FREE DOWNLOAD]

Dear Friends, This is a very simple yet powerful Excel VBA tip for you. Many a times before sending your workbook with Excel VBA Macro code in it, you want to save your workbook without any VBA code in it. Therefore here in this article, I will show you - how to save your Excel Workbook without excel macro in [...]

3 Methods to Comment or Uncomment in Excel VBA

Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate level users also does not know about all these options to comment a line or group of lines in Excel VBA. Like every other programming languages, VBA too has an option to comment a line or group of lines in your code. For those [...]

Hide Group outline symbol in Excel – [Manual Option + VBA]

Dear Friends, In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently. How to show or hide Group Outline Symbol in Excel Workbook when you group any row or column. Here I will show you both the methods - 1. How to hide Group Outline - Using [...]

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

Page 1 of 41234