Anyone have ideas on the Public Variant problem I posted about 5 or 8 posts ago

K

kylekelsch

Anyone have ideas on the Public Variant problem I posted about 5 or 8
posts ago
 
P

paul.robinson

Anyone have ideas on the Public Variant problem I posted about 5 or 8
posts ago
Click to expand...

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
 
K

kylekelsch

That was exactly what it was. Thank you for your response I've been
at this all day.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have a document with 8 different templates on it. 1
Word doc keeps changing to ALL CAPS 0
Ubound for variant not working for some reason, can anyone see why? 1
"Posted To" Field in Public Folder Posts 0
loop through only public functions? 1
VBA word change keys 0
Public Variant problem 0
trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this d 0

Top