1 When hiring a painting contractor, paint and supplies make up about 15-25 percent of the cost, while 75-85 percent goes for labor. 2  Costs typically average $1,500-$3,000 for an average single-story, three-bedroom home, but easily run $3,000-$5,500 or more for a multi-story or multi-level larger house. Choose the best quality paint you can afford; it lasts longer. 2  Experts estimate that the outside of a house should be painted every 5-7 years, but less-expensive paint may start peeling or fading in 4 years or less while really high-quality paint will hold up a bit longer.
Re: VBA code for suming a dynamic column range will this macro help you. VB: Sub test() Dim r As Range, j As Long, k As Long j = Range(A1).End(xlToRight).Column For k = 1 To j Set r = Range(Cells(1, k), Cells(1, k).End(xlDown)) r.End(xlDown).Offset(2, 0) = WorksheetFunction.Sum(r) Next k End Sub.
The PasteSpecial VBA Command: Get VBA to Do the Hard Work for You. VBA or Visual Basic for Application is an integration of Microsoftâs VisualBasic with MS office applications such as MS Excel. VBA is run within the MS Office applications to build customized solutions and programs. These enhance the capabilities of those applications. Today we look at the important Paste Special feature of Excel and VBA. We assume that you have working knowledge of MS Excel and VBA.