Hello All,
I am having a subscript out of range error 9 and I can't solve it.
the error is at the level of Perfect_Match(i, 1) = Tag(i, 1)
HTML Code:
Hello All,
I am having a subscript out of range error 9 and I can't solve it.
the error is at the level of Perfect_Match(i, 1) = Tag(i, 1)
HTML Code:
TryPlease Login or Register to view this content.
If Range("tag") has any blank cells, dim_tag will be smaller than Range("tag") and so will the Perfect_Match array.Please Login or Register to view this content.
While i <= UBound(Tag) will go beyond the bounds of Perfect_Match. Does that help?
Perhaps you want...
Please Login or Register to view this content.
Last edited by AlphaFrog; 04-15-2020 at 08:53 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I did . It works great thx.
Thx AlphaFrog
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks