Notice that the top version uses a "Set" statement. And I need the parens there. The bottom version just calls workbooks.open and doesn't require them. dk_ wrote: Dave, Thank you very much for your help, your patience, and for the excellent lessons! Very much appreciated! I am curious why the following statement needed () around the file's path?...

For #2. Technically, you don't need to declare your variables. If you don't put "Option Explicit" at the top of the module that contains that procedure, you don't need to declare any variable. I think that this is a very, very bad idea. I think each variable should be declared--and declared as the correct type ("as range", "as workbook", "as worksheet", "as long", "as variant"). But

Glad you got it working, but I don't understand your comments. If you look at the original code that I suggested, there was a line that declared ActSheet. So I think that you made a change (however minor) to that suggested code (or changed your own code???). That's why I asked to see the code that you were currently running. dk_ wrote: Dave, I got ActSheet to work...

Dave, 1) The active sheet is a worksheet, yes!!!! :) I see that I have edited the 'name' on the worksheet tab, in each of my 6 workbooks, if that makes any difference. And there is a named range on each of the 6 worksheet/workbooks named: "QuoteArea". I have a button on each sheet that I click on, to run the macro. I have 6 workbooks that I look at, one at a time, and I manually click

Dave, I followed your explanation (just below), and that was what I assumed the Set line was supposed to work, but I still couldn't get 'ActSheet' to work in my original macro. Here's what I tried... I used your set line... Set ActSheet = ActiveSheet as one of the frist few lines in my original macro, and then I inserted ("ActSheet") in place of ("Ben.xls") as in the following line