Re: Instrrev function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Don,

Tried that and it proves the point. Where I had the difficulty was in
retuning the clomun reference not as an index but as the actual 'name' from
an address. The problem arises when as the column name can be one character
(A-Z) then goes totwo characters (AA-etc). I was using the intersect
function to find a value for a particular date. One of the ranegs then is
the column in which the relevant date is found. The date could be in any
column from A- the end column, and the address for the cell having the date
in it returns as $A$11. I realise the easiest way in this instance would be
simply to remove the last three characters as I am always using the same row,
but I wnated to make the code more flexible. So to get the column reference
for the range value,I had to strip off every other character from the last
'$', leaving only the absolute column reference. I tried using the column
reference address.column, but that returns the index value which range cannot
use in the intersect function.

Thanks though for the comment.

Regards

DavidC

"Don Guillett" wrote:

try this with/wo the +1
MsgBox Len(ActiveCell) - InStrRev(ActiveCell, "b") + 1

--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"DavidC" <DavidC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8F7DEFF-2557-49C3-B82E-8AC63AC03636@xxxxxxxxxxxxxxxx
Hi,

Hope this is noted by Microsoft.

I have been using the Instrrev function in my code and could not figure
out
why I was getting the 'wrong' answer. Well I was reading the description
in
help too literally. The description states
"Returns the position of an occurrence of one string within another, from
the end of string." So my understanding was that it counted the number of
characters back from the end of the string and gave a number equal to the
number of characters back from the end of the string. In fact what the
function seems to do is to search the string from the end of the string,
and
give the number of characters where the particular character occurs from
the
START of the string. This 'error' gave me a few minutes of figuring out.

My suggestion to Microsoft is to make the descriptor a little more obvious
and state that the SEARCH starts from the end and it returns the number of
characters from the START of the string.

Regards

DavidC



.

Relevant Pages

  • Re: ToUpper() Better solution
    ... be aware that there is a Microsoft VisualBasic method ... European languages (Latin characters). ... characters (which will be the accents) with the empty string. ...
    (microsoft.public.dotnet.general)
  • Re: How to convert Infix notation to postfix notation
    ... If this is for an error message, why isn't it using stderr for its output? ... array of 15 characters, and you call this function with the limit 15 on ... Making sure that the only string I allocate and append to, ... because mulFactor in all versions must needs incorporate the functions ...
    (comp.lang.c)
  • Re: algorithm to compare 3 array elements
    ... but the back reference doesn't. ... So if you make the regex global (adding ... return string; ... characters, and not skipping the first two. ...
    (comp.lang.javascript)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)
  • Re: Delimiting problems
    ... prcise it is the reference to the beginning of the string. ... > What is the above code to delimit new lines before characters? ... "LISP is worth learning for the profound enlightenment experience ...
    (comp.lang.c)