I am using the following code to select the values in col A of a table where the value in Col G is TRUE
On the first iteration of the for loop I get the error message "Type Mismatch"
Please Login or Register to view this content.
AllAr looks fine in the Locals window.
What is wrong with TrAr?
Help Please
John
you have dim'd TrAr as a variant but are treating it as an array within the loop.
You can treat it as an array but only if you make it a variant array.
Please Login or Register to view this content.
Andy Pope,
Many thanks for your reply. I now see what to do and it works perfectly.
Sorry for the delay in my reply, I was pulled off the project for a while
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks