I've worked around this by having the user enter a "space" in the cell and
then continue on. Entering a space will enter the default value for that
column.


Quick other question I'm hoping you can help with when I use "Target.Column"
I get the number "1" how do I use the number to reference a cell at
A12 with the worksheets("mysheet").range().value ???