This is by no means a fix, but in the future, I've found it easier t
reference worksheets by their sheet number.
In the VB Editor, the upper left window (Project Explorer) lists th
sheet by name, then by number in parenthesis (SheetX). Instead o
Worksheets("sheet2").Range("B15"), you can use Sheet2.Range("B15")..
unless of course, your sheet has a different number.

-Gitcyphe

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