Okay I am having some trouble writng a code that takes a value from
Range("k3") and then searches a set Range("J10:J34,L10:L34") for the
first blank cell. When the first blank cell is determined the code
will need to initialize the cell with a name, and then move over
(right) one column and insert the value taken from Range("k3"). Does
anyone have any idea how this can be accomplished?