VBA: Name added to Range but not showing up with VLOOKUP

[bamaisgreat]

I have had to make some changes to some ranges to make them dynamic and a result of this is my formula below will not work anymore.

=IF(ISERROR(VLOOKUP(S5,Operators,2,FALSE)),"",VLOOKUP(S5,Operators,2,FALSE))

The range named Operators use to be just a normal range but now it is one that can only be found in the name manager. This is the "Refers To" of this range
=OFFSET(LIST!$H$1,1,0,COUNTA(LIST!$H:$H)-1,2)

when a name is a added to the Dynamic range it will not show up anymore

[TMS]

Please post a sample workbook.

Regards, TMS

[ag273n]

hi bamaisgreat...

i got this... if it helps... =)
the code executes as soon as a cell is clicked within worksheet1

Please Login or Register  to view this content.

if this helps, click my star =)