|Posted by:||Carl Johnson (bjohns…@woh.rr.com)|
|Date:||Wed, 15 Oct 2003|
Thanks Geoff and Dave, the code you gave me works great. Just one quick
Dave in the code you gave me there was a line that says
myAddr = Worksheets("Sheet1").Range("Customer").address
Now when I change the name of the worksheet to something other than sheet1 I
get a debug error. Is there a way to correct this. Again Thank you.