Does the Worksheet have to be active to do this?

[DChambers]

When I run the following line of code sCorrectMFGName shows ""

sCorrectMFGName = Worksheets("MFG").Range(B7).FormulaLocal

There is a Worksheet named MFG, Range B7 has "Atmel"

Is there something worng with my code or does the worksheet have to be active or selected?

 

[Jonmo1]

Maybe that was just a typo, but you need quotes around B7

Also, try .Value instead of .FormulaLocal

 

[DChambers]

Haven't looked up Val VS FormulaLocal not sure what the difference is but will find out.

Thanks

 

[Jonmo1]

FormulaLocal will return the FORMULA, Value will return the VALUE.

If the cell doesn't contain a formula, FormulaLocal will return the value of the cell.

 

[DChambers]

Thanks Jonmo1 always wondered about that.