Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro module

Macro module

ResolvedVersion 2003

Tue 24 Feb 2009, 16:36 Delegate Hitomi said...

Hitomi has attended:
Excel Advanced course

Macro module

What is module in Macro?

Fri 27 Feb 2009, 15:07 Trainer Carlos said...

RE: Macro module

Hi Hitomi

Visual Basic for Application (VBA) is the language in which all macros are written.

Modules are where you put most of your VBA code consisting mainly of basic macros and custom functions.

A VBA Project can contain as many modules as you want making it easy to split the procedures into different modules for organization and ease of maintenance.

Hope this helps

Carlos

Thu 5 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips

Macro module

Macro module

RE: Macro module

Excel articles

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet