![]() Then the code loops through each of those cells, performs the tax calculation and writes the results into your new column (column 5). ![]() This code finds the last row in your sheet of data, and then sets the range of cells (the column with the sales prices) according to the first and last row of data. Set rng = ws.Range(ws.Cells(2, 4), ws.Cells(LastRow, 4)) LastRow = ws.Cells(ws.Rows.Count, StartCell.Column).End(xlUp).Row The following code will accomplish all of these steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |