Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
With Range("ss_ACTIVEPORTFOLIOS") .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 End With End With CallRangeResets 'Resets all the ranges to include the new row ''NEED NEW ROW SORT HERE
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel VBA - set conditional format rules precedence||3||85|
|Import / Pull out data with condition from various excel registers to main excel file||10||56|
|VBA - Why copy area and paste area arent the same size error?||3||46|
|need count all combination||31||29|
Join the community of 500,000 technology professionals and ask your questions.