Re: Leading 'Text' zero's - comparing ranges

From: Kobayashi (Kobayashi.13a6nf_at_excelforum-nospam.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 15:12:53 -0600

Frank,

I appreciate the help but couldn't get that to work?

Tom,

Yet again, many thanks. Simply copied your code and plonked it in, made
a few minor adjustments so that it picked up my already defined ranges
and hey presto! Works like a dream!

Can I ask why the apostrophe is being added though in the following:
cell.Value = "'" & sStr? I'm only asking to aid my understanding so
that, one day, I can stop troubling you all and just maybe start
contributing myself!

Again, many thanks! 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: devfsadm running.
    ... Another Tom wrote: ... > CPU. ... Is it's running related to SDS? ... > and it is somewhat troubling since I thought it was for adding/removing ...
    (comp.unix.solaris)
  • Re: 700/23 vs 700/25 tires ?
    ... Tom, Mr Chung is contributing better humor than you this week, as noted above. ...
    (rec.bicycles.tech)
  • Re: New Way to Factor
    ... Tom St Denis wrote: ... > really not contributing anything. ... Why don't you tell that to the clueless fellow who ...
    (sci.physics)
  • Re: New Way to Factor
    ... Tom St Denis wrote: ... > really not contributing anything. ... Why don't you tell that to the clueless fellow who ...
    (sci.crypt)
  • Re: New Way to Factor
    ... Tom St Denis wrote: ... > really not contributing anything. ... Why don't you tell that to the clueless fellow who ...
    (sci.math)