How to make a large code by using a reference cell?

Hi,

The question is basically the title, however, let me make it more clear.

Let's say that you have a program of 10 lines that refer to several cells that should be copied and pasted back and forth. That program is related to a button.

So, let's say that you should have 20 buttons that do basically the same but refers to different cells, meaning that the program is identical to the other but instead of refering to cells in the 20, 21, 22, 23 row, they are refering to cells in the 32, 33, 34 row.

Meaning that the program is similar, but the job of changing all the reference points to the 10 lines for each button will be a big job.

So, by solving this, I think that refering to one reference cell in the form of "Range("B2")" and then use this point as a reference and offset the other cells from this one.

Any idea how to do this?

Ok, will do!


E.G:

Please Login or Register  to view this content.

So, imagine the code above has the same cells on the right side of the equal sign (sheet2). But the cells on the left side are changing for each button that I want to set the code to.

Meaning that all the cells are at same relevant distance to "A1" at "Sheet1", but they would be placed different on the sheet so I basically should be able to copy the right side of the code, get a reference point on the top cell at "sheet1" and then offset all the other cells downwards in the code.

Does that make it clearer?

Thanks for the reply btw!