On Mar 8, 6:53 pm, wrote:
Anyone have ideas on the Public Variant problem I posted about 5 or 8
posts ago

Hi
I wonder if your selectionChange event is triggering when you don't
expect it to? This might change what is going into the VLookup and
giving you the NA error?? You would have to do a careful watch of your
variable values as you step through your macros.
regards
Paul