Thread: VB arrays and Excel

Due to limitations of Excel, I’ve decided to write VB to solve the problem. The Excel “If” statement is too limited as is the “Case” command in VB. What I am wondering is can VB use a spread sheet as it’s source to build an array? If so, how do you access the array from excel to populate cells on a spreadsheet? Any help would be awesome. Thanks.

Hi

Can you give an example structure, and what you would like to be able to do? May be different ways to approach the solution so knowing what you have in mind will help.


rylo