We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
'Save data to Settings worksheet If Me.optActivePortfolios Then With Range("ss_ACTIVEPORTFOLIOS") With .Rows(.Rows.Count + 1).EntireRow.Insert .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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|vba search, delete, and enter 0 for entire sheet row A||13||29|
|what program/tool is used to create charts like this?||4||39|
|Shared files and folders migration||2||30|
|WORKDAY formula question||4||11|