Hi, Welcome to JustAnswer. This is Mahbub Shahin can assist you.Please let me know when you will be ready?
Please run the file
You can ignore the error with On Error Resume Next.
sorry, what file?
I mean the spreadsheet
Okay I did - got the same error. Didn't get On Error Resume Next.
Could you please send me the file
Did you get it?
Please upload here
I tried using the paperclip to attach but clicking OK doesn't attach
Click on the link then upload the file and send me the link
Now I am out side my home.
The speed is not too fast
It appears English is not your first language - do you mean you are not able to work on my issue at the moment because it is slow to upload the file?
Actually my download speed is slow currently.
I am apologize. I opt out and leave this question for other experts.
Please do not rate me.
Please rate the person who solve your problem.
That worked fine.
Have discussed with assistant who actually uses this and NOW she says she's been ignoring an error when the file first opens
Worksheets("Data").Visible = xlSheetVisible
Worksheets("Data").Visible = xlSheetInvisible
It stalls at xlSheetInvisible - and error is Can't find project or library
Ok that is really a different question. Please go ahead and rate my answer which has addressed the VLOOKUP error that you have initially asked so I can get credit for my time.Thanks
*** RATING REQUIRED ***
In the above code try replacing
xlSheeVisible with TRUE
xlSheetInvisible with FALSE
Already did that - doesn't work.
Fixed it myself.