Redefining Ranges

Giganews Newsgroups
Subject: Redefining Ranges
Posted by:  Carl Johnson (bjohns…
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.