Macro Recorder

Referring to Other Worksheets or Workbooks in an Excel Macro
Technology

Referring to Other Worksheets or Workbooks in an Excel Macro

Move to a powerful stage in your Excel macro-building progression. Read here how to access information in another workbook with a macro that is part of a different workbook.
By Bill Jelen | August 24, 2011
Read More
Spreadsheets: Using Text-to-Columns in a Macro
Technology

Spreadsheets: Using Text-to-Columns in a Macro

The thorny problem of reformatting data quickly that comes in from another department is solved using a combination of Excel’s text-to-column and macro recorder.
By Bill Jelen | August 17, 2011
Read More