This tutorial will outline an approach to create a macro, which will enable users to insert rows across workbooks. The following presentation is a follow-up…
Excel VBA Dynamic Ranges
This video will outline how to write a VBA dynamic ranges macro. It will enable users to seamlessly select a changing data range. We will…
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…
How to extract the last word in a string with Excel VBA
This macro that will extract only the last word in a string across a selected cell range.
Excel VBA how to move a sheet x times to the right
This video will show how to move a worksheet multiple times to the right in a workbook. Users will choose how many sheets to the right to move the worksheet.
Excel VBA insert columns all sheets
We are going to present one approach to insert multiple columns, in the same active column across all worksheets in an active workbook.