Relative reference problem
Hi,
I'd like to start a macro by clicking on a macro button, which copies a couple of cells. The values of these copied cells have to be pasted as values to the active cell.
E.g.: the active cell is C46. Now I press the button which copies cell AG23:AR23.
The values of AG23:AR23 are to be copied into C46:N46
The active cell is changing all the time though, therefore the cell reference has to be kept relative.
Thanks in advance,
Norbert
|