Hi Liz,
Unless you write to another "Report" sheet, you probably won't be able to build a report of discontinuous ranges.
One workaround -- Copy the ranges as pictures and paste into a report.
Select the range. Hold down the shift key and pull down the Edit menu -- select Copy Picture. Do this for the rest of the named ranges and create your report.
You are copying screen shots here, so if the data changes, the picture will not update.
HTH,
Jay
Like this thread? Share it with others