code snippet below. Is there a shorter way to do this type of
Thank you also. I will take this for a spin. I also appreciate the quick
response.
"Mike H" wrote:
Hi,
Maybe slightly better
myarr = Array("type", "employer_name", "employer_url", _
"employer_category", "employer_logo", "employer_bio", _
"first_name", "last_name", "address_1", "address_2", _
"city", "state", "Zip", "Password")
Range("B1:O1").Value = myarr
Mike
"Solutions Manager" wrote:
Range("A1").Value = "email"
Range("B1").FormulaR1C1 = "type"
Range("C1").FormulaR1C1 = "employer_name"
Range("D1").FormulaR1C1 = "employer_url"
Range("E1").FormulaR1C1 = "employer_category"
Range("F1").FormulaR1C1 = "employer_logo"
Range("G1").FormulaR1C1 = "employer_bio"
Range("H1").FormulaR1C1 = "first_name"
Range("I1").FormulaR1C1 = "last_name"
Range("J1").FormulaR1C1 = "address_1"
Range("K1").FormulaR1C1 = "address_2"
Range("L1").FormulaR1C1 = "city"
Range("M1").FormulaR1C1 = "state"
Range("N1").FormulaR1C1 = "zip"
Range("O1").FormulaR1C1 = "password"
|