I have code that works, but it feels crude. I'm filling a row of cells with chemical element symbols. Is there a better way than the code below?
'FILL TOP ROW WITH ELEMENTS IN CLASSICAL ORDER
Range("A1").Select
Range("A1") = "Standard"
Range("B1") = "C"
Range("C1") = "Mn"
Range("D1") = "P"...