Change cell format to lowercase in VBA code

[rachel.dudley]

Hi,

I use some VBA code to send an email with various cells values out..

I have changed some of the formats of the cells before the email is sent and then back to "general" at the end of the code so they don't change in the cells, just in the email.

E.g.

Please Login or Register  to view this content.

Then back to normal at the end of the code with:

Please Login or Register  to view this content.

I want to know if I can do the same with changing something to lowercase and then back to normal at the end of the code? I only wish for it to be lowercase in the email.

I have googled a lot but I can't seem to find anything that fits what I want.

Thanks for any help at all. This has been frustrating me for days.

[Chris 53]

How about using 2 variables one the original value and one the lowercase value.

dim original, lowercase

original = range("c8").value
lowercase = lcase(original)

range("c8") = lowercase.

send the email

then range("c8") = original.

[rachel.dudley]

That works great, thank you so much.