Thanks a lot Cucchiaino,
It did not work. The value at column E and C are string. earlier
pull the example for only one cell, I am working for about 5000
entries in the database.

Those values at $AB$3:$AB$71" and ("$AB$3:$CR$3" are also string wit
two letter code.

The error message comes in E5 and C5. I also tried to select the shee
(Sheets("Macro").Select) in the workbook of bharat.

Based on the code in column c and E, this vba code should be able t
grab a value. Then this value will be used to as an coefficient 1 fo
the formula of Coeff1+Coeff2*Value from column D.

Sorry I may not be able to explain the problem.

Thanks a lot for the help.

cheers
Bharat

Thank you
Cheers
Bhara

--
bharatPosted from http://www.pcreview.co.uk/ newsgroup acces