Union across multible worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assembling large "array" 3
Variable range union 1
Union Method with multiple worksheets 3
Union over multiple sheets 8
combobox population question 1
Excel Run-time error '1004' General ODBC Error 1
Combining Multilple Worksheets Into One 6
How to hide password? 1

Back
Top