untested, but a couple things you could try:

First, instead of referencing a cell ("A12"), give the cell a Rang
Name (markone) and use that in your code:

Markone = Range("markone").Value
this has the advantage of not requiring the sheet name to identify
this may only work within the same workbook.

Second choice, use the workbook and sheet name in your reference:

Markone = Range("[BOM_NEW]sheet1!A12").Value

Of course, adjust references as needed...

HTH

Bruc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=38280