Is there any way to get the result to show in a cell? What I would like is to count the number of worksheets (including hidden sheets) that are in a workbook up to and including a sheet named "SAMPLE", and then have this number displayed in cell BA on a sheet titled "ADMIN".