Hi All,
I need to iterate through several dozen closed workbooks and capture infor from several named ranges in each workbook and paste that data into another open workbook. I have a procedure and a fuction which orks with formula ranges such as "B2", "F29" "G76" etc., but it will not work...