View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Chris T-M Chris T-M is offline
external usenet poster
 
Posts: 43
Default "Or" statement not working

New to VBA. Please explain what a TRIM issue is. MS VB Help didn't provide an
explanation I understood how to apply.

FYI: Looking at the text again for a space, I noticed that my cursur jumped
all 3 periods together. I've seen MS Word "fix" typing like this, but could
this be why a macro isn't seeing "..." (presumably one character), and "..."
(three characters) as the same?
Chrs T-M

"Don Guillett" wrote:

You may have a TRIM issue?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Chris T-M" wrote in message
...
It is the text "Fill in..." The first letter capitalized, the rest lower
case, and 3 periods, copied from the cell into the Macro using Ctrl+C, &
Ctrl+V. There is also conditional formatting to set the color if the cell
no
longer says "Fill in..." or is blank, and a Validation - Input Message.

(PS: Replying to me at 10:30 on a Friday night seems above & beyond the
call
of duty, but I do appreciate it.)

"Bill Renaud" wrote:

OK, what is the formula (or complete value) in Range("Q44")?

--
Regards,
Bill Renaud