Good afternoon all.
I have four separate macros on one spreadsheet that each copy and insert a range of cells, moving the rows beneath the inserted cells down.
The macro inserting the first range of cell works consistently and correctly, and can be used multiple times.
The remaining three three don't insert consistently where they are directed. As I am not sure how many rows may have been added prior to the macro is run, I have named a reference cell and find that cell at the beginning of the macro and insert the copied cells one row up. This works for a while for each macro, but at some point, the cells begin to insert randomly when the macro is called.
I am stumped. Any ideas will be greatly appreciated.
Bookmarks