View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] 6afraidbecause789@gmail.com is offline
external usenet poster
 
Posts: 21
Default Method 'Range' of object '_Worsheet' failed in Union of 3 Ranges

Thanks again Peter--ok, the same error is occuring at
set r1 = Range("Range1")
in the above code.

Any other suggestions?