Your with statement is actually pointing at that specific workbook.

You can use this:
with activeworkbook
(for the workbook)

or
with activesheet
(for the active sheet)



newbie wrote:

I'm just starting out...
How do I get my macro to use the active worksheet.
before I used the filename:
With Workbooks("Calculatron.xls")
but I had two copies of the file, and the macro would only work in the
original file.
thank you...

--

Dave Peterson