I am having the same problem. The thing is that I am using the wizard but the value of the range is not showing in the worksheet. How will I look up to that?