<a
href="http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming &mid=127739c5-cb43-423a-b963-855688533e0f&sloc=en-us"Earlier</a
I had asked about a Range problem. Eventually, I played around and solved it
simply by moving the macro from being associated to one of the worksheets to
being associated with "This Workbook."
I don't understand why this made a difference since I was referred to
specific worksheets in the code.
This begs a few questions:
1) Is it better form to associate a macro with a specific worksheet or to
the workbook?
2) If I'm associating the macor to a worksheet what are the limitations?
Thanks,
David