Fit Worksheet to Window in Excel


Have you ever felt Excel needed a Fit-Document-to-Window-Width feature like the millions of PDF Readers out there? Wouldn’t it be great if you could automatically fit your document to your current window size? The irony is, Excel already has all it needs to deliver that feature to you. Since spreadsheets come in various shapes andContinue reading “Fit Worksheet to Window in Excel”

When do I use the Sheets Collection in Excel VBA?


There are two collections in Excel-VBA that lets the user access sheets in a workbook: the Sheets collection and the Worksheets collection. You can use these collections interchangeably in most situations, but they were each created for a specific purpose. Read on if you’d like to know more about why Microsoft created those two collections and theirContinue reading “When do I use the Sheets Collection in Excel VBA?”