vba courses london - Array

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Array

Karin has attended:
Excel VBA course

by - delegate Karin [1 post] (2007 Apr 13 Fri, 16:21) Reply

how do I use the worksheet function beta, using arrays in VBA?

RE: array

by - trainer David gold contributer [428 posts] (2007 Apr 25 Wed, 14:29) Reply

Hi Karin,

Sorry for the delay in getting back to you, I have been trying to figure out what you are trying to do.

It would really help if you could expand on what it is you are try to achieve and exactly what you want to do with 'the worksheet function beta, using arrays in VBA'

Thanks
David

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips