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

vba

ResolvedVersion Standard

Stuart has attended:
Excel VBA Intro Intermediate course

VBA

what is the difference between a variable and a variant?

RE: VBA

Hi Stuart

A Variable is used to store temporary information that is used for execution within the Macro or Module

On the other hand a Variant is a Variable Data type.

Id the Variable is declared without a data type the computer defaults the data type to Variant.

Hope this helps

Carlos

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

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.09 secs.