Selection Contains Space(s)?

[Frankbelly]

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.

 

[Jezebel]

If instr(Selection, " ") > 0 then

 

[Frankbelly]

Perfect!

Once again, thank you so much Jezebel

If instr(Selection, " ") > 0 then

 

[Frankbelly]

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

 

[Tony Jollans]

There are several ways. here's one:

if len(trim(selection)) = 0

 

[Frankbelly]

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.