It appears that the variable "shArray(i)" is null. Thus your type mismatch error.
FYI, adding "MsgBox shArray(i)" after "x = shArray" displays an empty message box.
It appears that the variable "shArray(i)" is null. Thus your type mismatch error.
FYI, adding "MsgBox shArray(i)" after "x = shArray" displays an empty message box.
Regards
Rick
Win10, Office 365
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks