Excel VBA is a great programming language because it allows you to do more with Excel and it's greatness has nothing to do with the syntax of the language.

For example you cannot dimension an array using a variable instead you need to first dimension your array as an empty array, arr(), then redimension your array.

-- Example Code Start --
Dim arr() as Variant
ReDim arr(N)
-- Example Code End --

If you get the following error:
" Compile Error Constant Expression Required "

That error is caused by inappropriately dimensioning your array with a non-constant value, a variable.

Thanks for watching,
Lucius LaFromboise
www.engsuite.org

Taking Excel to The Next Level Playlist: [ Ссылка ]

Getting Started with Excel VBA: [ Ссылка ]

Oftentimes Excel gives cryptic error messages that don't give much information which is why we have created a new playlist to help address these errors:
[ Ссылка ]

свернуть