hi bagullo
I think in 2003 you need to declare the sheet name

Test:=$a$1:$a$5
Sheet1!Test:=$a$1:$a$5

it been a while since i`ve use 2003