Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2003

Matthew has attended:
Excel Advanced course

Macros

What format of info can I pull in?

RE: Macros

Hi Matthew

A macro is a record of instructions in code that enable the computer to do something automatically

So as long as the code is written correctly the computer will follow it to the letter.

As an example the following macro ask you for a name and then displays the given name in a message box:

Sub Test

Dim AName as String

AName = InputBox ("Please enter a name")

Msgbox AName

End Sub

Hope this helps

Carlos

Mon 9 Feb 2009: Automatically marked as resolved.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.45 secs.