Conversation Between bdb1974 and mikerickson

BDB, about the refEdit control. The Text returned is an address your line sett

Set myRange = RefEdit.1.Text
should be
Set myRange = Range(RefEdit1.Text)