Macro to determine size of each tab in workbook

Hi Leith

I see what you mean, my first thoughts were to split the tabs into seperate workbooks and then return the individual workbook sizes but the spike in sizes is outside any acceptable range, can you suggest how I might get around the splitting and just produce the RESULTS tab within the active workbook?

thanks a lot

Noel