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
Dynamic range in excel using Index misses off last row. Why?
Solved by I. A. in 18 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 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
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?