Make Macro dynamic when Rows are Added

[RLONG98]

Hello,

I have a workbook with Marco1 that:

Highlights J95:M103
- Merges
- Center
- Adds Text "OK TO PAY"
- etc...

Macro 2
- Undoes the whole thing (Unmerge, Unformat)

ISSUE:
When/If new line(s) are added/deleted above, the Marco does not change, and eventually moves and may overlap used cells.

QUESTION:
Hot to make J95:M103 to be dynamic. Perhaps based on a where a value is listed on that row?

Thank you
Rob

[Vraag en antwoord]

Remove unnecessary code from the macro recording.
probably this maybe sufficient.

Please Login or Register  to view this content.

Please Login or Register  to view this content.