LinkBack URL
About LinkBacks
Hello SteveM,
VBA handles arrays a little oddly. Generally, you need to create a Variant Array. Here is an example.
Dim nArray As Variant ' Load nArray with a variant Array of Long values. nArray = Array(9&, 8&, 7&, 6&, 5&, 4&, 3&, 2&, 1&, 0&)
Hello SteveM,
VBA handles arrays a little oddly. Generally, you need to create a Variant Array. Here is an example.
Dim nArray As Variant ' Load nArray with a variant Array of Long values. nArray = Array(9&, 8&, 7&, 6&, 5&, 4&, 3&, 2&, 1&, 0&)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks