find particular words and do the action..

[VBABEGINER]

Dear All,
In my Col A, I have fixed words, which I want to make them in small letters only.
words are,

and, at, is, for, of, or

Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter...

Pls share the code...

 

[VBABEGINER]

Any possibility..

Dear All,
In my Col A, I have fixed words, which I want to make them in small letters only.
words are,

Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter...

Pls share the code...

 

[Special-K99]

What happens if these words begin a sentence?
You don't want them small then do you?

e.g.
For example...
At 5pm this afternoon I finished work
Of all the bars in all the towns in all the world...
Is it really necessary to...

Does this have to be a VBA solution?
Are you absolutely sure those are the ONLY words you want to put into lower case?

 

[VBABEGINER]

No matter, the position.

Yes, I want only mentioned in small letters..

What happens if these words begin a sentence?
You don't want them small then do you?

e.g.
For example...
At 5pm this afternoon I finished work
Of all the bars in all the towns in all the world...
Is it really necessary to...

Does this have to be a VBA solution?
Are you absolutely sure those are the ONLY words you want to put into lower case?

 

[Special-K99]

You didnt say whether it had to be a VBA solution.

 

[VBABEGINER]

im looking for vba solution..

You didnt say whether it had to be a VBA solution.

 

[Special-K99]

I'll have to leave this for someone else as I;m no expert in VBA.

 

[VBABEGINER]

No Matter, Thanks so much for reply..

Pls anyone, Try..

I'll have to leave this for someone else as I;m no expert in VBA.