Single cell a1 has array entered as 1,4 7,9,16. I am using split function to transfer the numbers to an array. I want to validate the numbers are in the range
1-30 and also find the length of the array.
Single cell a1 has array entered as 1,4 7,9,16. I am using split function to transfer the numbers to an array. I want to validate the numbers are in the range
1-30 and also find the length of the array.
Did you intentionally exclude the comma between 4 and 7 ?
Please Login or Register to view this content.
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.
Yes, it was.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks