The solution to find the problem is simple, if you know where the data comes from then do a manual import of the data to a separate sheet and record a macro of this process then compare the 2 vba codes to see the difference.

I don't have a unitab account other wise i would do this for you, last time i went to open one they wanted a $400 deposit.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________