Ok, thank you very much, works perfectly. I concede that what i want to do needs a sub and can't do it solely with a function.

Another question related to this project, much simpler I hope. I have a cell of text with a certain color which i have named 'text'. In another cell I am trying to call that cell (+text). How can i have '+text' be the same color as 'text'? Some sort of conditional formatting? Thanks again.