This video will demonstrate how to write an Excel VBA macro, which will dynamically select a data range based on changing rows of data.
Goal: Create a macro to select dynamically changing rows ranges of Excel spreadsheet data.
Delete empty columns in Excel
This presentation will offer one way to delete empty columns from selected columns in Excel.
How to freeze panes across multiple Excel sheets, multiple workbooks
This tutorial will present a macro-based solution, which will allow you to freeze panes in all worksheets across open workbooks.
How to unfreeze panes across multiple Excel sheets
Goal: Enable Excel users to unfreeze panes in the same position, across all worksheets in an active workbook. This tutorial will present you with a…
How to freeze panes across multiple Excel worksheets
This video and tutorial will show how to freeze panes in all worksheets in a workbook. Excel only permit a user to freeze panes in one worksheet at a time.
How to extract the first word in a string with Excel VBA
Goal: A macro that will extract the first word in each cell string in a selected cell range. This post will show you one way…