Here are some problems that our users have asked and received explanations on
I need help with VBA, i am trying to insert data into the first row but this code inserts it in the last row.
Solved by K. J. in 29 mins
i need vba code for excel to find the last cell of data in a variable column and to then add data beneath this
Solved by E. H. in 24 mins
Data is grouped into four groups. 1. Vegetables 2. Fruits 3. Flowers 4. Grains
I need VBA code to insert a row in selected group with same data as of last row in that group but enter new produce name ie apples or rose for that new row
Solved by G. H. in 14 mins
i need assist with some vba coding
Dim ws As Worksheet
Dim irow As Long
Set ws = Sheets("sheet1")
irow = ws.Cells(ws.Rows.Count, 1).End(x1up).Offset(1, 0).Row
The last line keeps coming out as an error?
Solved by I. H. in 14 mins
In cell C1, use a formula to find If values exist in column A and B of the row, then concatenate the last name first, a comma, a space, and the first initial of the first name into column C of the corresponding row