You could create a user defined function. You should be able to find more
info here

http://www.ozgrid.com/VBA/Functions.htm


"billy boy" wrote:

I know You cannot enter, or nest, no more than seven levels of functions
within a function. I need 8, is there any possible solution to get 8?

Thanks