Consolidate Repetitive Macros using Variable and loop

**eggselent** · 03-13-2022, 02:07 PM

Hi,

I have attached a sample. This is a basic macro that copy's from the "Line" Tabs & Pastes to the "Prior Line" tabs. I'm calling out each tab by name in separate macros and wanted to try to consolidate it and make it better. There are a few other tabs in the workbook that do not have to be changed at all. Any help would be appreciated. Thanks

**6StringJazzer** · 03-13-2022, 02:39 PM

Replace all of your code with this (tested).

Also, variable lr was undeclared. I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

Please Login or Register  to view this content.

**eggselent** · 03-13-2022, 08:12 PM

Thanks Jeff, and thanks for the link to declaring variables. As I'm sure you can tell im still at the frankenmacro stage

**6StringJazzer** · 03-13-2022, 10:13 PM

Hey, good start.

Consolidate Repetitive Macros using Variable and loop

LinkBack

Thread Tools

Rate This Thread

Display

Consolidate Repetitive Macros using Variable and loop

Re: Consolidate Repetitive Macros using Variable and loop

Re: Consolidate Repetitive Macros using Variable and loop

Re: Consolidate Repetitive Macros using Variable and loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Consolidate repetitive code - (populating two comboboxes from an advanced filter)

VBA/Macros - sorting across multiple repetitive columns

Loop to shorten repetitive and long code?

Consolidate Repetitive Data

Loop for repetitive code

repetitive macros-solved

Convert repetitive IF statements to array loop?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions