View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Union across multible worksheets

It's easy to "Union" ranges w/in a sheet but I can't figure out how to do so
with ranges in multiple sheets. I keep getting a 1004 error. It seems to work
only with the active sheet.

Help