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.
VBA To Hide/Show Rows & Columns. I am hoping to find someone that can write this piece of VBA code. I have no experience with it myself, other then basically copying & pasting solutions into the VBA editor. In those cells, there is either no value IE  or 1. If the cell has a 1, then I would like that row / column hidden. Here are some screen shots so you can see what I'm doing... (Keep in mind the images doesn't show the full range) I would like this code to execute (show & hide) when the values in those cells change.