About 173 results
Open links in new tab
  1. 3 Ways to Copy and Paste Cells with VBA Macros in Excel

    Jul 1, 2015 · Bottom line: Learn 3 different ways to copy and paste cells or ranges in Excel with VBA Macros. This is a 3-part video series and you can also download the file that contains the …

  2. How to Use VBA Macros to Copy Data to Another Workbook in Excel

    Jan 9, 2019 · Bottom Line: Learn how to use VBA macros to copy & paste data from one Excel workbook to another, including adding data to the bottom of an existing range or replacing data.

  3. 3 Ways to Fill Down Blank Cells in Excel - Excel Campus

    Oct 21, 2020 · But is there an easy way to replicate that process hundreds of times for reports that have large amounts of data? In this post we'll look at three ways to automate this process …

  4. How to Avoid the Select Method in VBA & Why - Excel Campus

    Jun 2, 2016 · We don't need to select any sheets or ranges for this simple copy and paste action. The following macro accomplishes the same task without the Select method, and only requires …

  5. How to Copy or Import VBA Code to Another Workbook

    Oct 11, 2018 · Learn four simple yet effective ways to insert code into a worksheet or your personal macro workbook. This allows you to transfer and share macros among various …

  6. 3 Ways to Remove Duplicates to Create a List of Unique Values in …

    Oct 19, 2017 · Of course we can use our old friend VBA to make this process much faster with a macro. In the video above I show how we can use a macro to complete the entire process with …

  7. Automate Excel with VBA and ChatGPT

    May 7, 2025 · In this article, I will show you how to automate Excel with VBA and ChatGPT using Excel's hidden Macro Recorder and AI-powered code improvement. This combination will help …

  8. How To Copy & Paste Visible Cells Only - Excel Campus

    Jul 16, 2014 · Have you ever tried to copy and paste a range with hidden rows or columns and didn't get the results you expected? This problem can be frustrating and time consuming! In …

  9. The Ultimate Guide to Excel Filters with VBA Macros - Excel Campus

    Jul 13, 2018 · Especially when we are applying filters to multiple columns on large worksheets, or filtering data to then copy/paste it to other worksheets or workbooks. This article explains how …

  10. 3 Ways to Add or Subtract Days to a Date - Excel Campus

    Dec 20, 2017 · Learn 3 different ways to add or subtract days to dates in Excel using formulas, copy & paste, and VBA macros. Includes video tutorial.