live worksheet
Excel Sheet Size Check
Excel Sheet Size Check. Sub sheetsizes () dim ws as worksheet with createobject (system.collections.arraylist) for each ws in activeworkbook.worksheets.add ws.name & & ws.usedrange.cells.count & cells used next ws sn =.toarray. If by the size of the sheet you just mean, how many cells are in the used range, then this code can do it.

Instead of executing step 1 and 2, you can also use the insert tab to insert a check mark symbol. How can i put the outcome of sheet.dimensions in 2 variables. Free to try with no limitation in 30 days.