#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 64
Default InstrRev Issue

I am trying to find the position of the last occurance of "\" in my string
using the below and all I get is 60 (always - i tried changing the position,
string etc) which does not seem to be correct.

MsgBox InStrRev(.FoundFiles(i), "\")

Can anyone suggest what am I doing wrong?
--
Ajit
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default InstrRev Issue

Syntax
InStrRev(string1, string2[, start[, compare]])
The InStrRev function syntax has these parts:

Part Description
string1 Required. String expression being searched.
string2 Required. String expression being searched for.
start Optional. Numeric expression that sets the starting position for each
search. If omitted, -1 is used, which means that the search begins at the
last character position. If start contains Null, an error occurs.
compare Optional. Numeric value indicating the kind of comparison to use
when evaluating substrings. If omitted, a binary comparison is performed. See
Settings section for values.


--
HTH,
Barb Reinhardt



"Ajit" wrote:

I am trying to find the position of the last occurance of "\" in my string
using the below and all I get is 60 (always - i tried changing the position,
string etc) which does not seem to be correct.

MsgBox InStrRev(.FoundFiles(i), "\")

Can anyone suggest what am I doing wrong?
--
Ajit

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak Excel Worksheet Functions 8 August 22nd 07 08:05 AM
EXCEL: How to scan text reversed (like ACCESS: InStrRev)? 4mula_freak[_2_] Excel Worksheet Functions 3 August 21st 07 01:19 PM
Excel error: Undefined Function 'InStrRev' in Expression TerryD Excel Worksheet Functions 4 February 6th 07 02:43 PM
is there a instrRev function in excel functions? schuurke28 Excel Worksheet Functions 1 October 28th 04 03:05 PM
is there a instrRev function in excel functions? schuurke28 Excel Worksheet Functions 1 October 28th 04 11:25 AM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"