i would like to know how to use vba codes to run regression ('cause i could not use "record macro" to get it .., ), please provide me with sample codings if possible. thanks