If the size of your array increases and you don't want to fix the size of the array, you can use the ReDim keyword. Excel VBA then changes the size of the array automatically. Add some numbers to column A. Place a command button on your worksheet and add the following code lines:1. First, we declare the array named numbers. Also declare two variables of type Integer.One named size and one named i.f the size of your array increases and you don't want to fix the size of the array, you can use the ReDim keyword. Excel VBA then changes the size of the array automatically. Add some numbers to column A. Place a command button on your worksheet and add the following code lines:
Prices vary all over but on average the cost is about the same. Around 3/3.50$ a s/f for refinishing and a s/f for a medium grade of carpet and pad installed. Check out both but I have to agree about the house value being a bit higher with finished hardwood.
Note that darker stains can push the per-square-foot cost up a little. And some companies will charge a minimum of about $450, regardless of job size. For recoating: About $1 per square foot. Refinishing a vintage or high-end wood floor: About $5 per square foot. $2.50 to $5 per square foot. 2  Do-it-yourself: The cost for items needed for do-it-yourself refinishing, including a commercial sander, buffer, and finish solution, typically range from $150 to $500. 3  Timing: Hardwood floor refinishing can take two to four days, depending on the size of the room.