Paste to location based on Cell contents

Hello,

Within a VBA macro I need to copy a known row (this bits easy) but paste this row to a variable starting cell location specified as a value of a known cell.

So for example, I can get my macro to select cell A1 but then want to copy the contents of this to a cell location specified in say, cell A10.

Eg.
If the contents of cell A10 is B40 for example, the macro would copy the contents of A1 to B40 (on the basis that the value B40 is the contents of A10).

Hope this hasn't confused too much....

Thanks in advance, RMT.

Try this feel free to modify as you wish!

Please Login or Register  to view this content.

Regards,
Simon

Will try this Simon, thanks. RMT.