rw = 12
col = Target.column
msgbox Worksheets("mysheet").Cells(rw,col).Value

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
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 ???