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