Copy from static destination & paste to dynamic destination

Hi!

I need a macro to do the following:

1. Copy text I have written in cell "J12" of Sheet1.
2. Paste the text in a destination cell in Sheet1 specified by a dynamic row number generated in cell "J6" and a static column number (column F, which is column number 6).
3. I will link the macro to a button in Sheet1 and the macro must execute without visibly moving around in the sheet and without leaving blinking dashed lines around the cell from which the text was copied.

Can anyone help me with this, please?

Hi, thanks! Yes, that looks right. I pasted the code between Sub Macro1() and End Sub, but gets Run-time error '424': Object required. What more is needed? I'm green at VBA...

Hi! You're right; I edited Sheet1 to the tab name I used for the sheet. It worked when I used your code unedited!

Hi!

I have the following function in cells L6, P6 and T6 to generate random numbers: =RANDBETWEEN(2;27649)

The numbers go into the VBA below in order to copy and paste varying info from cells J11, N11 and R11 into cells in column F with row numbers corresponding to the randomly generated numbers in L6, P6 and T6, respectively.

However, I want the randomly generated numbers to have no repeated values for the given range. That is, if a cell in column F is not empty, the row number for that cell will not be generated by the random function, because it has already been used.

Any ideas on how to solve this?

Please Login or Register  to view this content.