| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code snippet below. Is there a shorter way to do this type of thin
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorter Code | Excel Programming | |||
| Problem in WITH/END WITH code snippet | Excel Programming | |||
| Code snippet storage | Excel Programming | |||
| MaxRows 65536 in a sheet - A Code Snippet | Excel Programming | |||
Threaded Mode
