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

Variable

ResolvedVersion 2003

Thu 30 Oct 2008, 16:29 Delegate Kylee said...

Kylee has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Variable

What's a Viariable?

Mon 10 Nov 2008, 10:18 Trainer Carlos said...

RE: Variable

Hi Kylee

A Variable is a name used to represent a value in VBA.

They are used to represent values that may change during the procedure and identify a unique location in memory.

The syntax is Dim/Public/Private VariableName [As type]. eg:

Public PivotSelection As Byte

Hope this helps

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Variable

Variable

RE: Variable

Excel articles

Excel tip:

Formula for last day of month