Hello Friends, I have created one Excel Workbook which can calculate all types of GTIN. It calculates following types of GTINs: GTIN -8 GTIN -12 GTIN -13 GTIN -14 To know more about the GTIN Calculator and How to Calculate GTIN... Read this ArticleIf you want all GTIN...
Results for "column"
Excel Tips : Enter Current Date Without Typing in to the Cell [Static]
Shortcut key to type current date in excel cell [Static] Static changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it. If you want to...
Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)
Let's take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use...
How to get Excel Range in Array
Many times while developing an application in Excel VBA, we need all the values stored in an excel Cell Range in an Array variable. So that at any point in time we can access the value from the array, rather than going to Excel Cell and reading it from there. Also,...
Excel Macro Tutorial : Excel Form
In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going...
Assigning Macro : How to assign macro to Hyperlink ?
So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article, you are going to learn how to run a macro by using...
User Defined Function in Excel to Convert Currency to Words
Many times we require to change the Numbers in Words. For Example 6734862=Sixty Seven Lakhs Thirty-Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers into Words. I have written one UDF : User Defined Function. After using...
Name Range in Excel
How to Name Range in Excel: Hello Friends, It's been long time, I did not post any Article. So today I thought of writing one Article on one of the most useful features in Excel. I am talking about the Ability to Provide meaningful name for various items or Cell...
How to Import Delimited Text File in Excel
In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is Comma delimited Text file or Pipe Delimited Text File etc. This file you want to export in to Excel in such a way that Delimiter is treated as a...
Shortcut Keys in Microsoft Excel
Hello Friends, Here I am going to list down some useful Shortcut Keys. These keys are very useful in your day to day excel use. By making these shortcuts in practice you can do many of the things in Excel Easily. Key Description CTRL+( Unhides any hidden rows within...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
5 very useful and small macros
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used...
Assign a Hot Key to a Command Button in Excel
In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command...
Assign a Shortcut Key using Excel VBA
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel...