Thread: parse cell contents
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default parse cell contents
On 26 Sep 2006 09:37:37 -0700, wrote:

I figured out how to get the code to work that sets a reference. No
matter which code I run the line: strDate = REMid(c.Text, PatternDate)
strDate comes up empty, when I hover over it I get empty double quotes,
even when the only content of the cell is 1/1/2006



That is in accord with your specification. You wrote:

"If there is a date, it must be formatted like: yyyy-mm-dd and it must
be the first thing."

1/1/2006 is m/d/yyyy (or d/m/yyyy) but it clearly is NOT yyyy-mm-dd


--ron
Reply With QuoteReply With Quote