ExcelMacros

Excel Macros / Macros for Excel

Macros Scripts for MS Excel:

Row Hierarchy Breakdown:

• ExpandCellText.vb - Splits a row into columns depending on grouping or indentation with adding cells to the right or left with autofill (selecting options using dialog boxes)

• ExpandCellText_Mod1.vb - Splitting a row into columns depending on grouping or indentation with adding cells to the right or left with autofill (selecting options using dialog boxes, entering the maximum number of groupings in advance)

• ExpandCell_Left.vb - Splits a row into columns depending on the indentation with adding cells to the left

• ExpandCell_Right.vb - Splits a row into columns depending on the indentation with adding cells to the right

• InsertOrRemoveRow.vb - Adding or removing a row while maintaining formulas

Library of external functions for calling from Excel macros

You can find the library and macros HERE