Get instant live expert help on I need help with vba last row
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
can you help with a VBA question. We are trying to write a macro that copes down to the last row. Every new spreadsheet has a different number of rows
Solved by A. A. in 13 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 K. A. in 15 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
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
Solved by F. C. in 11 mins