Using a &%$#%$ RefEdit box to work with a multi sheet range - solution or overkill?

[Jacob Hilderbrand]

I would use Application.InputBox to select the range instead of using a RefEdit box. If the user wants to select from multiple sheets then just store the address from the Application.InputBox to a public variable and let them add to it with Union.