ExcelBanter - Union across multible worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Union across multible worksheets (https://www.excelbanter.com/excel-programming/311800-union-across-multible-worksheets.html)

Jeff

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

Dave Peterson[_3_]

Union across multible worksheets

Union returns a range.

Ranges are limited to single sheets.

Jeff wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 04:01 AM.