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

excel vba

ResolvedVersion Standard

Xavier has attended:
Excel VBA Intro Intermediate course
Excel Advanced - Formulas & Functions course
PowerPoint Intermediate Advanced course

Excel VBA

What is a variant?

RE: Excel VBA

Hello Xavier

Thank you for your question

When you declare a variable in VBA, you normally define the type of variable. For example,

Dim varDate as Date, creates a variable varDate and sets it so it will only accept date data.

Variant is a catch all data type. It can contain any kind of data except fixed length string data. You can use it when you when the type of data that a variable is to take will vary depending on cionditions that may alter as the procedure runs

Hope this helps

Regards

Stephen

RE: Excel VBA

thanks

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

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.