Quote Originally Posted by mvidas
Then again, I'd say I use VBA much much more than I have to, as I'd rather see
=getname(A1)
over
=VLOOKUP(A1,'[BC data.xls]4420 processed'!$A$1:$D$30,4,FALSE)
You can use names to do just that, you don't need VBA. One of my points earlier.