heres a little known trick in excel 2007>
options/customise/all commands
scroll down and add speak cells to your quick access toolbar
now select a range of populated cells and click the speak cell icon
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
run macro