Tagged Questions
3
votes
1answer
433 views
Excel for Mac 2011: UBound() Not Working
I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011.
I have a function (Source) that searches arrays for a specified value:
Function ...
2
votes
2answers
3k views
Load contents of CSV file to array without opening file
I have a requirement to collate over 6000 csv files into a single csv document. The current VBA process is:
1. Open individual CSV data file
2. Load contents of file to array based on number of rows
...
-2
votes
2answers
171 views
Find the value inside of boudary using array [closed]
I need your help on this.
I have a table with a heading that contains "TOD Status", "Grand total". At the bottom of the "Grand total" column I have the totaled value. In addition, the header needs to ...
