Skip to content

Spreadsheet Vault

Financial modelling, Modano financial models and Excel spreadsheets

  • Excel
    • Charts
    • Data Tools
    • Developer
    • Forecast
    • Format Cells
    • Styles
  • Functions
    • Basic Functions
    • Intermediate Functions
    • Advanced Functions
  • Macros
    • Basic Macros
    • Intermediate Macros
    • Advanced Macros
  • Modano
    • Financial Modelling
  • Consultancy Services

Category: Basic Macros

  • Home
  • Macros
  • Basic Macros
  • Home
  • Macros
  • Basic Macros
  • Basic Macros

Automatically highlight the active row in Excel

Goal: To write a simple worksheet macro event, which will highlight the active row that our cursor is on. Download Spreadsheet Vault SpreadsheetVault – Highlight…

Read More
  • Basic Macros

Loop through rows in a column in Excel VBA

This feature will show you how to write a simple loop of columns in a row. We will compose a simple looping macro based on a basic parameter.

Goal: Demonstrate to Excel users how to write a basic looping macro through rows in a column.

Read More
  • Basic Macros

Loop across columns in a row in Excel VBA

This tutorial will walk you through a simple loop of columns in a row. We will show how to write a simple looping macro based on a simple parameter.

Goal: Show Excel users how to compose a simple looping macro across columns in a row.

Read More
  • Basic Macros

How to convert formulas to values in Excel

Goal: Offer a more seamless, instant approach to convert formulas to values in a selected range of cells to their respective values. This is an…

Read More
  • Basic Macros

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…

Read More
  • Basic Macros

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.

Read More
Copyright © 2025 Spreadsheet Vault. All Rights Reserved | Magazinews by Theme Palace