Refer to first cell in range

[ShaneDevenshire]

Hi,

I copied the code into a userform and it worked fine.

While in Debug mode put your cursor over rngAddr and see what Excel is
storing in the variable. If you haven't selected a cell in the RefEdit box
this will cause an error.