describing VBA commands/code

Hi everyone,

I need help explaining the purpose of each of the following commands and a short description if possible. They are numbered 1-6.

Please Login or Register  to view this content.

I'd really appreciate any help given, I'm kind of new to the whole programming thing.

Thanks in advance!

Cheers,

Zealot

Thanks Mike, here are what I think each does.

1. Option explicit prevents you from using a variable without declaring it. It makes VBA alert the user if an undeclared variable is used by inserting the Option Explicit statement as the first line in the module.

2. The line declares the variable "Temp", a variable which stores the value to be returned before actually assigning it to the functions name, as a double data type, which stores precision floating point numbers from –1.79769313486232E308 to –4.94065645841247E-324.

3. By setting ScreenUpdating to False at the Start of the macro, it is used to stop the constant screen flickering associated with recorded macro and is also used to speed up the execution of the macro. You use it when you don’t want to see your screen follow the actions of your VBA procedure as you won't be able to see what the macro is doing.

4. The entire command returns or sets a string value that represents the address of the target document in the active or specified window

5. Returns a range object in the active or specific window that represents the current region when chart element is selected.

6. Declares an array called “myArray”. The array has six elements, so I think that is the range of an index that can be used with the statement.

Sorry for the delay in reply, had some trouble with the last one.

Cheers