I am trying to combine data on two different sheets in the same workbook
using the following command:
Set Union_sh = Application.Union(Sheets("BSPL+"), Sheets("Other OMI"))

For some reason this won't work and I cannot understand why.