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.
If you record a macro and name a worksheet, and then open the macro code in the Visual Basic Editor, you will see something like the following code. VB. Copy. This code selects and names a particular sheet (Sheet1) in the workbook Sheets collection, but the goal of this scenario is to name the active worksheet.lick the drop-down arrow next to the Search button. Click Developer Reference, type event in the search box, and then click Search. The following sections describe how to decide which event to use for the event-handler subroutine for this scenario, and how to write the VBA code to name and sort worksheets.