Selection Contains Space(s)?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frankbelly - 27 Sep 2006 21:57 GMT

I'm trying to check to see if the current Selection contains one or more
spaces.

If I use Section = " " it only determines whether there is one space and
won't determine if there are multiple spaces in the selection. I need to
check if selection contains one or more spaces.

Any help is greatly appreciated. Thanks in advance.

Reply to this Message

Jezebel - 27 Sep 2006 22:14 GMT

If instr(Selection, " ") > 0 then

> I'm trying to check to see if the current Selection contains one or more
> spaces.
[quoted text clipped - 4 lines]
>
> Any help is greatly appreciated. Thanks in advance.

Reply to this Message

Frankbelly - 27 Sep 2006 22:41 GMT

Perfect!

Once again, thank you so much Jezebel

> If instr(Selection, " ") > 0 then
>
[quoted text clipped - 6 lines]
> >
> > Any help is greatly appreciated. Thanks in advance.

Reply to this Message

Frankbelly - 27 Sep 2006 23:00 GMT

Actually, I forgot one more thing. This is my fault. I'm only giving you a
part of what I'm trying to do.

Basically what I'm trying to do is remove only spaces in front of some text.
I have selected the area in question properly, but I need to make sure the
selection contains only spaces and not any other characters so I can safely
remove it. Ultimately deleting this space that exists (if any) in front of
the text.

Thanks again for any help

> Perfect!
>
[quoted text clipped - 10 lines]
> > >
> > > Any help is greatly appreciated. Thanks in advance.

Reply to this Message

Tony Jollans - 28 Sep 2006 06:19 GMT

There are several ways. here's one:

if len(trim(selection)) = 0

--
Enjoy,
Tony

> Actually, I forgot one more thing. This is my fault. I'm only giving you a
> part of what I'm trying to do.
[quoted text clipped - 21 lines]
> > > >
> > > > Any help is greatly appreciated. Thanks in advance.

Reply to this Message

Frankbelly - 28 Sep 2006 21:41 GMT

That worked perfectly. Thank you so much!

I'm an extreme Novice at VBA and this forum is great!

I try to figure things out on my own first, but when I hit a wall, it's nice
to know I have some place to go and get quality help.

Thanks again.

> There are several ways. here's one:
>
[quoted text clipped - 37 lines]
> > > > >
> > > > > Any help is greatly appreciated. Thanks in advance.

Reply to this Message