First of all, this really is an amazing resource!!
Now, to my query. Any help will be much
appreciated. I have attached the file. The row being copied is row "X" for both buttons
I have 2 buttons
in the same worksheet to copy a row and insert the
copied row below it. I have this macro running for 2 different rows in the worksheet, assigned to the respective 2 buttons.
See my code below.
Private Sub CommandButton1_Click()
Private Sub CommandButton2_Click()
The problem is:
1) I want just the
formulas/formatting to be pasted, and not the
2) And more importantly, if I use Button 1, then row 7 is copied and the copied row is added below row 7 and the rows move
down. But then, for Button 2, row 12 is different....now as it has moved down (it has become 13, but the macro for button 2
is still copying row 12), if you understand? How do I keep it fixed that it always copies the contents of row 12 even if a
row is added above and the rows move down, making row 12 into 13 and so on.