Hello mtma,
Your question is very broad. An example would help. If you just want a general answer, here is a way to grab all data from a sheet into an array:
Dim arr as variant arr = activesheet.usedrange.value
Hello mtma,
Your question is very broad. An example would help. If you just want a general answer, here is a way to grab all data from a sheet into an array:
Dim arr as variant arr = activesheet.usedrange.value
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks