PDA

View Full Version : [SOLVED] Starting paste data from a specific row



osevero
11-13-2013, 09:02 AM
Hi again! :hi: I'm really needing help to solve this problem. As an example, you can use this xlsm: 10825

This xlsm have a userform which is used to paste data starting at row 7, but I want to start pasting the data in row 8. So would be: row 6 = name of the column, row 7 = blank space, row 8 = the beginning collage data.

You can see the code in .xlsm but I can also transcribe here:


Private Sub CommandButton1_Click()

Range("B1048576").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select

ID = txt_id
Welder = txt_welder
Frequency = txt_frequency


ActiveCell = ID
ActiveCell.Offset(0, 1).Select
ActiveCell = Welder
ActiveCell.Offset(0, 1).Select
ActiveCell = Frequency
ActiveCell.Offset(0, 1).Select

MsgBox "Fare added"
Unload Me
UserForm1.Show

End Sub


So I need to change this code to start paste the data from row 8. Row 7 goes blank

Please help.

Are also trying to help me in this forum: http://www.excelforum.com/excel-programming-vba-macros/968038-select-the-first-row-without-data-1-a.html

Cheers

patel
11-13-2013, 10:32 AM
maybe you attached the wrong code, I can not see any statement with copy and paste

osevero
11-13-2013, 10:48 AM
Hi patel,


To see the code you have to open the VBA, and then go to UserForm1, and view code button "ADD". To test the code, go to sheet 1 and click the "Form" then opens a form to fill, you click the ADD button and the data is added in the correct column in sheet.