Is it good idea to keep my all data in the Array macro module . it is required for Excel Addins .Say for example. I am having almost 5000 data in the sheet 2 range (A1:B5000). & in sheet1 having just simple Vlookup formula to get the data from sheet 2. But I want that ,I will keep all data of sheet 2 range (A1:B5000) in the macro module by Array macro.& after that I will take out all desire data by vlookup. Below array macro running good , but it has limitation , it can’t store lost of data
what is best idea to keep all my data in the macro module ,I can hide sheet2 (which having actual data) but I want to know is it possible to keep all my data inside the macro module ? Without helping array macro as it has limitation. I have seen some VBA software & its having self hidden database (not cascade with access database)Please Login or Register to view this content.
Bookmarks