slow process

I'm trying to use a button in one workbook to open another Excel file, copy data from that file into an array, and paste some of the array data back into the original file (with the button) but on a different sheet than the sheet where the button is located. In the past, I've had no problems...

I have an unbelievably slow opening excel 2007 macro-enabled workbook that is only 950kb in file size. It’s got 2 worksheets, one is empty, and the other has about 1,000 records spanning 10 columns. The file also contains 3 short macros, one of them being a web data query. I’m trying to figure...

Dear frenz, i need a solution to fasten the process of my macro, its taking almost 1 hour to complete the process.....the macro as below Option Explicit Public Function MatchDigits(LookupValue As Range, LookupRange As Range) As String Dim Cell As Range Dim NewNum As String Dim...