Well... without actually seeing the code it's impossible to really sa
exactly what's going on, but you're probably exactly right. There ar
ways to point to certain objects that are not specific to any certai
object. For example, you can make changes to "ActiveWorkbook." Thi
is something that works fine if you know for sure that when your cod
is run the workbook you want will definitely be the active one. Ther
are plenty of other cases I could mention that would work or not wor
depending on the currently active workbook or worksheet. Unless yo
feel like posting your code I don't know what to say beyond that othe
than to make it more specific. - Piku

--
Message posted from http://www.ExcelForum.com