VB; using cell value instead of formula

[xatomicx]

Good day,

i am using a standard automated form for email, so i won't paste all the coding, but the line wich cause me trouble;

Please Login or Register  to view this content.

A18 refer to a vlookup formula wich works fine, it goes into a list of users and add the concerned person email in A18.

Please Login or Register  to view this content.

If i use the vlookup formula to get the email, when i send it, there is nothing in my outlook outbox, and excel/outlook don't return me any error. My guess is when asking excel to use A18 cell, it use the formula within it, instead of the actual value, and then outlook or excel nullify the vba request. Because if i go in cell A18 and enter the same email manually without the formula, it works.

solution? :/

[Norie]

Sheet2.Range("A18") will return the value in the cell, not the formula.

If it returned the formula you would see something like this in the cc field of the email.

[email protected];=IF(VLOOKUP(B2;X1:Y97;2;FALSE)=0;"";VLOOKUP(B2;X1:Y97;2;FALSE))

[xatomicx]

Ok, any clue why it doesnt work if i use vlookup but does when i input manually ? i dont get any error from excel nor outlook .. so can't know where it fails.

[Norie]

Can you post the rest of the code?