Are you sure that's what you're supposed to do because it's extremely poor practice. A function should be self contained. All values necessary for the completion of the function should either be contained within the function or passed in the function call. A Sub can use global constants. A function never should.