I am trying to understand what is the value of str especially when no initial state has been set.
When I analyse in immediate window it shows the first value as str ="word|" and cell = "word"; but without setting str var first, how is this even possible?
Please Login or Register to view this content.
What is str? Where did you assign a value for it? As it is, it is empty
Returns a Variant (Long) specifying the position of the first occurrence of one string within another
Syntax
InStr([ start ], string1, string2, [ compare ])
The InStr function syntax has these arguments:
Part Description
start Optional. Numeric expression that sets the starting position for each search. If omitted, search begins at the first character position. If start contains Null, an error occurs. The start argument is required if compare is specified.
string1 Required. String expression being searched.
string2 Required. String expression sought.
compare Optional. Specifies the type of string comparison. If compare is Null, an error occurs. If compare is omitted, the Option Compare setting determines the type of comparison. Specify a valid LCID (LocaleID) to use locale-specific rules in the comparison.
Last edited by AB33; 03-11-2022 at 01:55 PM.
str is being used to generate a unique set of cell values
with each cell being iterated - if the cell value is not found in the str variable (Instr = 0) the cell value is appended to str such that if found again it is ignored.
the final Split takes the resulting concatenation (of unique values) and splits them back out into unique items (c/o the pipe delimiter)
you will often see people use the Dictionary Object to do the same thing...
It isnt. Until the str = str & cell & | line has been executed, str is an empty string.Originally Posted by immigrated4urjob
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks