Re: runtime error 1004 help
Are you sure your RefEdit text is a valid range? The "_Global" doen't refer to declaration of variables. It is the default object when no object is defined. So if the text in your RefEdit does not repesent a valid worksheet or cell reference, you would get this error message. Bascially it means that the range in the RefEdit test is nowhere to be found within the Excel object. A blank RefEdit would return this error. Note that the RefEdit object can be manually changed and therefore does not always refer to a valid range.