excel vba

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel VBA

Excel VBA

resolvedResolved · Low Priority · Version 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:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Server loaded in 0.1 secs.