I have ranged names that go from column A to Column E. However, after updating data via a form, I need to sort the data, but it is based on the data in column F. How do I tell it to sort on Column F in the range?
.Rows(.Rows.Count + 1).EntireRow.Insert
With .Rows(.Rows.Count + 1)
.Cells(1, 1).Value = Me.txtAddedBy.Value 'You can now refer to cells in the new row as .Cells(1, 1), .Cells(1, 2), etc.
.Cells(1, 2).Value = Me.txtDateAdded.Value
.Cells(1, 3).Value = "Yes"
.Cells(1, 6).Value = Me.txtPortfolioCode.Value
.Cells(1, 7).Value = Me.txtPortfolioName.Value
.Cells(1, 8).Value = Me.txtURLSectorSummary.Value
.Cells(1, 9).Value = Me.txtURLSectorDetail.Value
.Cells(1, 10).Value = Me.txtURLRatingSummary.Value
.Cells(1, 11).Value = Me.txtURLRatingDetail.Value
CallRangeResets 'Resets all the ranges to include the new row
''NEED NEW ROW SORT HERE