Hi Don
I added "Public interval As Variant" below "Option Explicit" as adviced in macro of module "Module1" of Sheet "Change" of file "Analysis.xlsm"
Then added the 2nd updated macro in another module "Module2" of Sheet1(Sheet1) of file "Analysis.xlsm"
The 1st macro of module "Module1" is working perfectly once the "StartTimer" command is selected.
However, data from range G12:G25 of Sheet "WorkArea" of file "MarketWatch.xls" STILL DOESN'T appear on range A1:A14 of Sheet "Sheet1" of file "Analysis.xlsm" as required every five minutes.
I even tried the updated macro on a new sample file instead of file "Analysis.xlsm" but it still doesn't gave the required output of copy paste. Hence, I suspect something is still wrong or missing in the updated macro.
I have again attached both the files i.e. file."Analysis.xlsm" and file "MarketWatch.xls" for your reference and would appreciate if you can analyse why isn't the macro working.
Please note:
File "MarketWatch" is a streaming stock watchlist and it stops streaming if it is edited
Thanks
Viral