I want to write a subroutine that puts variables into cells in a table. The subroutine below works perfectly for the job except that I haven't found a way to have a variable in the formula:
.Cells(1).Range.Text = item
.Cells(2).Range.Text = desc
.Cells(3).Range.Text = qty
.Cells(4).Range.Text = price
In this routine above the formula is hard coded to row 3. How can I modify that line to make it use the row variable used in the first line of the code snippet?