Thanks Tom / Andrew.

Works fine now! Much appreciated !

===============================
"Tom Ogilvy" wrote in message ..
set basebook = Workbooks("Test.xls")

if it isn't always test.xls but it will be the active workbook

set basebook = ActiveWorkbook


"Blogd_Node" wrote in message

Hi,

Just starting coding VB in Excel.
Am more familiar with Access, so I know
just enough VB to be dangerous to myself...
:-)

I have a macro (in PERSONAL.XLS) which is run from within TEST.XLS.

In the line of code
set basebook = thisworkbook

"ThisWorkbook" refers to personal.xls and NOT test.xls.

How do I refer to the TEST.XLS ?