A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Why doesn't INSTREV work for me?



 
 
Thread Tools Display Modes
  #11  
Old February 21st, 2008, 04:05 PM posted to microsoft.public.excel.misc
Mike H
external usenet poster
 
Posts: 8,419
Default Why doesn't INSTREV work for me?

I should add I'm here

http://www.microsoft.com/office/comm...ang=e n&cr=US

Mike

"Rick Rothstein (MVP - VB)" wrote:

Do you have something against Ron?g (He also answered you.)


Clearly we have a posting problem because the only answers I see are
from you and I, nothing from Ron?


My newsreader shows Ron Rosenfeld as the first responder to this thread (his
message was posted approximately 4 minutes before mine was).

Rick




  #12  
Old February 21st, 2008, 04:28 PM posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_59_]
external usenet poster
 
Posts: 1
Default Why doesn't INSTREV work for me?

Nope,

In order
OP
You
Me.Same time as yourself


I show your post as coming in 4 minutes after mine.

OP +18 Minutes


However, I do see the 18 gap for the OP though.

Me
You
Me
You
and in a few minures this one.


With the exception of Ron's posts, I see the same message tree as you do.
Strange.

By the way, I see from your parallel post in this sub-thread that you are
using a web newsreader... I am using Window (Vista) Mail via a direct
account set up with the microsoft.public.excel.misc news server.

Rick

  #13  
Old February 21st, 2008, 04:32 PM posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_60_]
external usenet poster
 
Posts: 1
Default Why doesn't INSTREV work for me?

Ron, if you haven't already done so, you should read the sub-thread started
by Mike H... it seems that you posting is not visible in Microsoft's online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


"Ron Rosenfeld" wrote in message
...
On Thu, 21 Feb 2008 06:20:03 -0800, dsimcox

wrote:

I'm using INSTREV to retrieve the location of a character in a string by
searching from the end of the string.

When I type the following in the immediate window:

?InStrRev("1234567-89", "-")

I get an answer of 8.

I was expecting 3. (The position of the "-" is 3 characters from the
right-hand side of the string)

Am I interpreting this incorrectly?


Yes.

Although it starts looking from the end of the string, it still gives the
position numbered from the beginning of the string.

?InStrRev("12-34567-89", "-")

would give an answer of 9.
--ron


  #14  
Old February 21st, 2008, 05:16 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default Why doesn't INSTREV work for me?

On Thu, 21 Feb 2008 11:32:46 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Ron, if you haven't already done so, you should read the sub-thread started
by Mike H... it seems that you posting is not visible in Microsoft's online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


Thanks for the tip, Rick.

This is not the first time that I have felt ignored. I will check out that
link.
--ron
  #15  
Old February 21st, 2008, 05:36 PM posted to microsoft.public.excel.misc
Mike H
external usenet poster
 
Posts: 8,419
Default Why doesn't INSTREV work for me?

who said that? g

"Ron Rosenfeld" wrote:

On Thu, 21 Feb 2008 11:32:46 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Ron, if you haven't already done so, you should read the sub-thread started
by Mike H... it seems that you posting is not visible in Microsoft's online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


Thanks for the tip, Rick.

This is not the first time that I have felt ignored. I will check out that
link.
--ron

  #16  
Old February 21st, 2008, 05:44 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default Why doesn't INSTREV work for me?

On Thu, 21 Feb 2008 11:32:46 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Ron, if you haven't already done so, you should read the sub-thread started
by Mike H... it seems that you posting is not visible in Microsoft's online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


Nothing is apparent, although obviously you were able to see my post using your
newsreader and not going through the web version.

I have sent a tech support email to Forte (I use Agent as my newsreader) and
I'll see what they say. Whatever it is, it seems to be only an intermittent
problem. I notice that although my first response to the OP did not show up,
others of my responses did. In addition, your post to me shows up on the MS
newsgroup as a blank post from an unknown person!
--ron
  #17  
Old February 21st, 2008, 05:52 PM posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_61_]
external usenet poster
 
Posts: 1
Default Why doesn't INSTREV work for me?

I just looked back on the link you posted earlier... Ron is still not in the
original thread, but his latest post shows up in the new thread... strange.

By the way, this is the first time I have really looked a web newsreader...
what a horrible interface it provides... the same thread is broken up into
two (so far) separate threads even though the subject is the same and the
newer thread is really just a continuation of the older one. How does anyone
follow a continuous thread of posts if the (web) newsreader is breaking them
into separate threads with on apparent (at least to me) rhyme or reason?

Rick


"Mike H" wrote in message
...
who said that? g

"Ron Rosenfeld" wrote:

On Thu, 21 Feb 2008 11:32:46 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Ron, if you haven't already done so, you should read the sub-thread
started
by Mike H... it seems that you posting is not visible in Microsoft's
online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


Thanks for the tip, Rick.

This is not the first time that I have felt ignored. I will check out
that
link.
--ron


  #18  
Old February 21st, 2008, 05:55 PM posted to microsoft.public.excel.misc
Mike H
external usenet poster
 
Posts: 8,419
Default Why doesn't INSTREV work for me?

Curiouser & Curiouser the starter of this thread - presunably Rick - is
showing up as 'Unknown' to me. Clearly we have a gremlin of; as yet,
indeterminate origin

Mike

"Ron Rosenfeld" wrote:

On Thu, 21 Feb 2008 11:32:46 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Ron, if you haven't already done so, you should read the sub-thread started
by Mike H... it seems that you posting is not visible in Microsoft's online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.

Rick


Nothing is apparent, although obviously you were able to see my post using your
newsreader and not going through the web version.

I have sent a tech support email to Forte (I use Agent as my newsreader) and
I'll see what they say. Whatever it is, it seems to be only an intermittent
problem. I notice that although my first response to the OP did not show up,
others of my responses did. In addition, your post to me shows up on the MS
newsgroup as a blank post from an unknown person!
--ron

  #19  
Old February 21st, 2008, 05:55 PM posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_62_]
external usenet poster
 
Posts: 1
Default Why doesn't INSTREV work for me?

Ron, if you haven't already done so, you should read the sub-thread
started
by Mike H... it seems that you posting is not visible in Microsoft's
online
newsreader....

http://www.microsoft.com/office/comm...ang=e n&cr=US

I'm not sure why, or if this is an ongoing problem with your postings or
not, but you might want to try and discover why.


Nothing is apparent, although obviously you were able to see my post using
your
newsreader and not going through the web version.

I have sent a tech support email to Forte (I use Agent as my newsreader)
and
I'll see what they say. Whatever it is, it seems to be only an
intermittent
problem. I notice that although my first response to the OP did not show
up,
others of my responses did. In addition, your post to me shows up on the
MS
newsgroup as a blank post from an unknown person!


Yes, I just saw that and I posted a message back to Mike commenting what a
horrible interface the web newsreader provides. Not only is the new thread
shown as started by an unknown person (what is with that?), the thread is
totally separated from the original thread of which it is a part... my
question was, how does anyone follow a threaded set of postings if the (web)
newsreader is breaking them apart with no apparent rhyme or reason?

Rick

  #20  
Old February 21st, 2008, 06:04 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default Why doesn't INSTREV work for me?

On Thu, 21 Feb 2008 12:55:55 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

Yes, I just saw that and I posted a message back to Mike commenting what a
horrible interface the web newsreader provides. Not only is the new thread
shown as started by an unknown person (what is with that?), the thread is
totally separated from the original thread of which it is a part... my
question was, how does anyone follow a threaded set of postings if the (web)
newsreader is breaking them apart with no apparent rhyme or reason?

Rick


Poorly?
--ron
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 AM.


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