BobBarker
02-25-2011, 01:39 PM
I have a lot of code in my macro like the following example.
Is there a more efficient way of doing it by somehow selecting a larger range and using an array of string vars?
Range("E1").Select
ActiveCell.FormulaR1C1 = "Step 2"
Range("E3").Select
ActiveCell.FormulaR1C1 = "ID #"
Range("E5").Select
ActiveCell.FormulaR1C1 = "Address"
Range("E7").Select
ActiveCell.FormulaR1C1 = "City"
Range("E8").Select
ActiveCell.FormulaR1C1 = "Province"
Range("E11").Select
ActiveCell.FormulaR1C1 = "Postal Code"
Range("E13").Select
ActiveCell.FormulaR1C1 = "rank"
Is there a more efficient way of doing it by somehow selecting a larger range and using an array of string vars?
Range("E1").Select
ActiveCell.FormulaR1C1 = "Step 2"
Range("E3").Select
ActiveCell.FormulaR1C1 = "ID #"
Range("E5").Select
ActiveCell.FormulaR1C1 = "Address"
Range("E7").Select
ActiveCell.FormulaR1C1 = "City"
Range("E8").Select
ActiveCell.FormulaR1C1 = "Province"
Range("E11").Select
ActiveCell.FormulaR1C1 = "Postal Code"
Range("E13").Select
ActiveCell.FormulaR1C1 = "rank"