newrow

Hi Guys, I have a code below that works by finding the last row of the source file and paste it into the destination sheet of another workbook, all the data is stored from Column C to L. the transfer works fine but only Transfers C to J the misses out the last two cells. Can someone help me out...

Hi, I am trying to recreate a spreadsheet based on one I have been given. However, I am trying to ensure I understand the coding properly, I don't want to just cut and paste. I am also making some changes, hence another reason why I don't simply want to do this. The spreadsheet is based...

Hi All, I am trying to do two things with a userform. #1 : add a new row to bottom of existing table, the table is called "Table1". (my current code does this part just fine) #2 , populate the first cell in that new row with a textbox.text that is in a userform called UserForm1, the text box...

I am receiving a runtime error 91 for the following code. It occurs at the newrow = Nme.Range("L4:L70").Find(newnme).Row line. Private Sub Cmd_Add_Click() Dim nextrow As Integer Dim newnme, nxtnme As String Dim newrow, wkrow As Range Dim rw, n As Integer Set Wkly = Sheets("Weekly") Set Nme =...

Hello There is some misalignment when calculating in column J when button clicked. Will appreciate if anyone can help me to correct it in code below For the Following representation <tbody> ROWS H I J 1 NAME AMOUNT TOTAL 2 Xxxxx 5000 3 6000 4 4000 15000 =sum(H2:H4) This is...

Hi all, I need some code that finds the last row in a table (there will always be data in column a of the table) and insert a new row after. Can anyone suggest any code? Thanks, Ruby. :)