Hi Tom,
Look at the
http://www.mvps.org/dmcritchie/excel...d.htm#problems
for some things that could go wrong. You have to set the security to
Medium within Excel. If you have a message include the full text letter for letter with
punctuation of the error. You can use that within double quotes to search
Google Groups or as a Google web search..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Tom Russell" wrote
I did copy and paste your suggested macro into a new workbook according to
instructions in "Getting Started with Macros and User Defined Functions" but
got an error message I can't resolve. Maybe I will have better luck tomorrow.