thanks, was amazed i couldnt find anything that mentioned how the & worked when googling, just loads about the old Dollar sign! $$ thanks again. my sheet is going to do its own work when i finish this macro.