When using Excel, you probably spend a substantial amount of time dealing with worksheets. After all, Excel workbooks are composed of worksheets and most of the data you work with is contained, and analyzed, within worksheets. Consider, for example the following common worksheet operations: Creating a new worksheet, or deleting an existing worksheet. Changing the … [Read more...]

If you're anything like me, you probably spend a substantial amount of time working in Excel. The results of your efforts are probably beautiful and useful Excel worksheets. From time-to-time, you probably share the results of your work in Excel with others. 2 of the most common ways of achieving this are: Printing your worksheets. Saving your files as … [Read more...]

From time-to-time, you may need to use Visual Basic for Applications for purposes of working with fonts. For example, you may want to: Apply bold or italic style. Specify the font color or size. Set the characteristics of the text underline. If you're in a situation where you want to modify a font attribute, this VBA Tutorial should help you. My purpose with … [Read more...]